A collection of 19 FAQs on SQL Server Transact-SQL stored procedures.
Clear answers are provided with tutorial exercises on creating and
dropping stored procedures; retrieving and modifying stored
procedures; ending stored procedures properly; defining and passing
values through input and output parameters; temporary and permanent
stored procedures.
Please visit this Website.:
http://dba.fyicenter.com/faq/sql_server_2/Transact-SQL_Understanding_Stored_Procedures.html
TThank you,
Team DBAFYI - DBA Resource Center
http://dba.fyicenter.com