Quick Start Guide to SQL Server 7 -- Part 1

Databases:

• Launching your Server Taskpad
• Creating a Database
• Viewing your Database in Enterprise Manager
• Moving your Access database to SQL Server

Tables:

• Viewing your Tables
• Creating a Table
• Altering your Table
• Entering data into your Table
• Viewing your Table Properties

Data Types:

• List of all SQL Server data types

Security:

• Creating a Login
• Granting access to a user

Indexes:

• Creating an Index
• Running the Index wizard
• Managing your Indexes
• Running the Index Tuning Wizard

Relationships:

• Creating a relationship

VB Code:

• Skeletal ADO data access code

Views:

• Creating a View
• Editing your Views
• Granting user access to a View

Deleting, Renaming:

• Deleting an Object
• Renaming an Object

Defaults:

• Creating a Default
• Binding a Default
• Editing a Default

User Defined Types (UDTs):

• Creating a UDT
• Implementing a UDT

Rules:

• Creating a Rule
• Binding a Rule
• Editing a Rule

Transactions:

• How they Work, with VB Code

Triggers:

• Managing Triggers
• Sample Trigger Code

Stored Procedures:

• Creating a Stored Procedure
• Editing a Stored Procedure

Stored Procedure Examples, with VB code:

• SELECT Stored Procedure
• UPDATE Stored Procedure
• DELETE Stored Procedure
• INSERT Stored Procedure
• Output Parameters
• More Output Parameters

Page 2 of 5



This article was originally published on November 20, 2002