Stored Procedure How-to Topics
Like procedures in other programming languages, stored procedures in Microsoft SQL Server can be used to do the following:
- Accept input parameters and return multiple values in the form of output parameters to the calling procedure or batch.
- Contain programming statements that perform operations in the database, including calling other procedures.
- Return a status value to a calling procedure or batch to indicate success or failure, and the reason for failure.
In This Section
- How to: Create a Stored Procedure (SQL Server Management Studio)
- How to: Modify a Stored Procedure (SQL Server Management Studio)
- How to: Rename a Stored Procedure (SQL Server Management Studio)
- How to: View the Definition of a Stored Procedure (SQL Server Management Studio)
- How to: View the Dependencies of a Stored Procedure (SQL Server Management Studio)
- How to: Delete a Stored Procedure (SQL Server Management Studio)
- How to: Grant Permissions on a Stored Procedure (SQL Server Management Studio)
See Also
Other Resources
Stored Procedures (Database Engine)
Database Creation and Design How-to Topics