Export (0) Print
Expand All

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.

Community Additions

ADD
Show:
© 2014 Microsoft