Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET

Overview

There are seven types of Transact-SQL stored procedures:

• User-defined

• System

• CLR(.NET)

• Extended

• Temporary

• Global temporary

• Remote