January 27, 2021
Hot Topics:

Quick Start Guide to SQL Server 7 -- Part 1

  • By Karl Moore
  • Send Email »
  • More Articles »


  • 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

Data Types:

  • List of all SQL Server data types


  • Creating a Login
  • Granting access to a user


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


  • Creating a relationship

VB Code:

  • Skeletal ADO data access code


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

Deleting, Renaming:

  • Deleting an Object
  • Renaming an Object


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

User Defined Types (UDTs):

  • Creating a UDT
  • Implementing a UDT


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


  • How they Work, with VB Code


  • 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

Enterprise Development Update

Don't miss an article. Subscribe to our newsletter below.

Thanks for your registration, follow us on our social networks to keep up-to-date