Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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.

Community Additions

© 2015 Microsoft