dcsimg
October 15, 2018
Hot Topics:

Quick Start Guide to SQL Server 7 -- Part 1

  • November 20, 2002
  • 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



Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 


Enterprise Development Update

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

By submitting your information, you agree that developer.com may send you developer offers via email, phone and text message, as well as email offers about other products and services that developer believes may be of interest to you. developer will process your information in accordance with the Quinstreet Privacy Policy.

Sitemap

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