dcsimg
October 26, 2020
Hot Topics:

Quick Start Guide to SQL Server 7 -- Part 1

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

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

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