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

Show: