SQL Server 2000 Handbook Contents

1.            Contents

1.    Contents

2.    SQL Server Overview

Relational Database Terminology

SQL Server History

Sybase

SQL Server 4.2

SQL Server 6.0

SQL Server 6.5

SQL Server 7.0

SQL Server 2000

SQL Server Features

Transactions

Data Dictionary

Constraints

Structured Query Language

Enterprise Networking

Administration

Connectivity

Views

Triggers

Stored Procedures

Replication

User Defined Functions

XML

HTML

3.    SQL Tools

Service Manager

Enterprise Manager

Register the Server

SQL Query Analyser

OSQL

4.    SQL Syntax

pubs

SELECT Statement

Field List

WHERE Clause

Wild Cards

FROM Clause

ORDER BY

Natural Join

GROUP BY Clause

HAVING Clause

DISTINCT

Inner (Natural) Join

Outer Join

Sub Queries

UNION

FOR XML mode [, XMLDATA] [, ELEMENTS][, BINARY BASE64]

SELECT .. INTO

INSERT Statement

UPDATE Statement

DELETE Statement

5.    Database Definition

Enterprise Manager

Create a Database

Create a Table

Data Types

Nulls and Defaults

Table Ownership

Field Properties

Null Values

Default Constraints

Check Constraints

Create a Primary Key

Identity Columns

Unique Identifiers

Primary Key Constraint

Foreign Keys and Referential Integrity

User Defined Data Types

Defaults and Rules

Defaults

Rules

6.    Indexes

Unique Index Constraint

Clustered Index

7.    Views

Indexed Views

Check Option

Partitioned Views

OPENROWSET

Linked Servers

Temporary Tables

8.    Stored Procedures

Executing a Stored Procedure

Passing Parameters

Returning a Value

Output Parameters

Program Structures

Local Variables

System Variables

Scalar Functions

CASE Expression

Cursors

System Procedures

Extended Procedures

Extended Mail Procedures

Error Handling

Transactions

Distributed Transactions

9.    Triggers

Trigger Program Structure

Field Level Validation

Record Level Validation

Checking Values against another Table

Preventing Changes to a Field

Referential Integrity Checks

Checking a Foreign Key

Ensuring Unique Candidate Keys

Checking Referential Integrity on Delete

Cascading Delete

Updating another Table

10.      SQL Server Optimisation

Query Optimisation

Update Statistics

Index Design

Ordering

Showplan

SQL Trace

Optimiser Hints

Clustered Indexes

Index Tuning Wizard

Stored Procedure Recompilation

Deferred Updates

Locking Issues

11.      Configuration

Server Configuration

Memory

Lock Escalation Percentage

Network Packet Size

Open Databases

User Connections

Database Configuration

Size of tempdb

Truncate Log on Checkpoint

Deleting a Database

Backups

12.      Security

Server Logins

Database Users

Permissions

 

REDWARE CONNECTOR

Xero
Sage 50C
QuickBooks Online
Dynamics 365
SQL Server
Power BI
FREE TRIAL
About Us

Specialist billing software house working with Dynamics 365 and Power BI connected to Xero, Sage 50 and QuickBooks Online.

Find out more
Contact Us

 +44 203 1799 444

 sales@redware.com

 Redware Research Limited.
32 Welbeck Avenue, Hove BN3 4JL, ENGLAND.