November 28, 2014
Hot Topics:

Quick Start Guide to SQL Server 7 -- Part 1

  • November 19, 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.

Sitemap | Contact Us

Rocket Fuel