Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

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 details about working with stored procedures and user-defined functions, see the following topics:

To See
Create stored procedures and user-defined functions to be run on the database Creating Stored Procedures and User-Defined Functions
Use parameters in stored procedures and user-defined functions Using Parameters in Stored Procedures and User-Defined Functions
Open stored procedures and user-defined functions to view or edit the SQL text Opening Stored Procedures and User-Defined Functions
Save stored procedures and user-defined functions Saving Stored Procedures and User-Defined Functions
Run stored procedures and user-defined functions Running Stored Procedures and User-Defined Functions
Copy stored procedures and user-defined functions Copying Stored Procedures and User-Defined Functions
Delete stored procedures and user-defined functions Deleting Stored Procedures and User-Defined Functions
Use breakpoints with stored procedures, user-defined functions, and triggers Using Breakpoints With Stored Procedures, User-Defined Functions, and Triggers
Use Query Designer with stored procedures and user-defined functions Using Query Designer With Stored Procedures and User-Defined Functions
Run selected text in stored procedures and user-defined functions Running Selected Text in 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.

See Also

Developing Database Structure

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft