stored procedure in sqlserver 2005,Types of Stored Procedures in sqlserver 2005

There are many types of stored procedures available in Microsoft SQL Server 2005. This topic briefly describes each stored procedure type and includes an example