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 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


Related Sections

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft