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.