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

Topic Description

Running Stored Procedures (OLE DB)

Discusses how to run stored procedures using the SQL Native Client OLE DB provider.

Calling a Stored Procedure (OLE DB)

Discusses how to call stored procedures with parameters using the SQL Native Client OLE DB provider.

See Also

Concepts

SQL Native Client (OLE DB)

Help and Information

Getting SQL Server 2005 Assistance