Working with Stored Procedures and User-Defined Functions

Stored procedures and user-defined functions are collections of SQL statements and optional control-of-flow statements stored under a name and processed by the database server as a unit. Both stored procedures and user-defined functions are precompiled and ready for later use. Using Visual Database Tools, you can easily create, view, modify, and test stored procedures and user-defined functions.

For more information and examples of stored procedures and user-defined functions, see the documentation for your database server. If you are using Microsoft SQL Server, see "CREATE PROCEDURE" and "CREATE FUNCTION" in SQL Server Books Online.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft