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.

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.

Community Additions