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.
How to: Create Stored Procedures and User-Defined Functions
How to: Save Stored Procedures and User-Defined Functions
How to: Open Stored Procedures and User-Defined Functions
How to: Discard Changes Made to Stored Procedures and User-Defined Functions
How to: Use Parameters in Stored Procedures and User-Defined Functions
How to: Use Breakpoints With Stored Procedures, User-Defined Functions, and Triggers
How to: Modify Stored Procedures and User-Defined Functions
How to: Run Stored Procedures and User-Defined Functions
How to: Run Selected Text in Stored Procedures and User-Defined Functions
How to: Delete Stored Procedures and User-Defined Functions
How to: Show Stored Procedure Properties
How to: Show Function Properties