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.
In This Section
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
Reference
Reference (Visual Database Tools)