Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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