Stored Procedures

A stored procedure is an executable object stored in a database. SQL Server supports:

• Stored procedures

  One or more SQL statements that have been precompiled into a single executable procedure.

• Extended stored procedures

  C or C++ dynamic-link libraries (DLLs) written to the SQL Server Open Data Services API for extended stored procedures. The Open Data Services API extends the capabilities of stored procedures to include C or C++ code.

In This Section

• Running Stored Procedures (OLE DB)

• Calling a Stored Procedure (OLE DB)

See Also

Concepts

SQL Server 2008 R2 Native Client (OLE DB)