Profile

e-Catalog

Contact

Search

Cart

Microsoft Visual Basic 6.0 Distributed: Building SQL Stored Procedures

Audience

Visual Basic enterprise developers

Prerequisites

The Microsoft Visual Basic 6.0 Desktop curriculum; advanced Microsoft Visual Basic 6.0 programming skills; an understanding of the essentials of database development

Course Aim

To show how to write SQL stored procedures

Learning Objectives

Write SQL statements to access and manipulate data. Use the Data View window to create stored procedures. Debug stored procedures. Use Transact-SQL.

Topics Covered

Introduction to SQL statements - Introduction to Microsoft SQL Server - SQL statement syntax - Hands-on: Creating SQL statements - Combining data from multiple tables Creating stored procedures - Using the Data View Window - Hands-on: Creating a stored procedure - Adding parameters to a stored procedure - Hands-on: Adding stored procedure parameters - Debugging a stored procedure Transact-SQL - Declaring variables - Flow control statements - Hands-on: Adding flow control statements - SQL transactions