Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQs - Transact-SQL Understanding Stored Procedures
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.
Topics included in this FAQ are:
- What Are Stored Procedures?
- How To Create a Simple Stored Procedure?
- How To Execute a Stored Procedure?
- How To List All Stored Procedures in the Current Database?
- How To Drop an Existing Stored Procedure?
- How To Create a Stored Procedure with a Statement Block?
- How To End a Stored Procedure Properly?
- How To Generate CREATE PROCEDURE Script on an Existing Stored Procedure?
- How To Get the Definition of a Stored Procedure Back?
- How To Modify an Existing Stored Procedure?
- How To Create Stored Procedures with Parameters?
- How To Provide Values to Stored Procedure Parameters?
- What Are the Advantages of Passing Name-Value Pairs as Parameters?
- Can You Pass Expressions to Stored Procedure Parameters?
- How To Provide Default Values to Stored Procedure Parameters?
- How To Define Output Parameters in Stored Procedures?
- How To Receive Output Values from Stored Procedures?
- How To Create a Local Temporary Stored Procedure?
- Can Another User Execute Your Local Temporary Stored Procedures?
Please note that all answers and tutorials are based on MS SQL Server 2005.
To follow tutorials in this collection, you should connect to SQL server
as a regular user who has enough permissions to run simple Transact-SQL statements.
To follow tutorial exercises in this collection, you need to use test tables created
from previous tutorial collections.
(Continued on next topic...)