Introduction to SQL Server Stored Procedures

Duration: 2 days

Overview:

This course leverages the programming extensions to the Transact-SQL language to allow attendees to create robust procedures that improve the performance and security of applications.

Prerequisites:

To get the most out of the Microsoft T-SQL Server course, you should have a solid understanding of relational databases. No particular programming experience is required, but the course is taught from a developer's perspective.

Topics:

1 - Stored Procedure Design Concept

Overview

Anatomy of a Stored Procedure

Creating Stored Procedures

Altering Stored Procedures

Limits

2 - Functionality

Returning Result Sets

Using Input and Output Parameters

Using Return Values

Default Values

Passing Parameters by Name

3 - Types of Stored Procedures

Managing Stored Procedures

Viewing Code of Stored Procedures

Renaming Stored Procedures

Deleting Stored Procedures

Listing Dependent and Depending Objects

4 - asic Transact-SQL Programming Constructs

T-SQL Identifiers

Data Types

Character Strings

Unicode Character Strings

and Time Data Types

Integer Numbers

Exact Numbers

Monetary Data Types

Binary Data Types

Special Data Types

5 - Variables

Local Variables

Declaring Variables

Assigning Values with the Set Statement

Assigning Values in the Update Statement

Displaying the Values of Variables

Global Variables

Table Variables