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