Quick Start Guide to SQL Server 7 -- Part 1
- Launching your Server Taskpad
- Creating a Database
- Viewing your Database in Enterprise Manager
- Moving your Access database to SQL Server
- Viewing your Tables
- Creating a Table
- Altering your Table
- Entering data into your Table
- Viewing your Table Properties
- 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