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.