Stored Procedures

Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW) SQL database in Microsoft Fabric

Download OLE DB driver

A stored procedure (Stored Procedures (Database Engine)) 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

OLE DB Driver for SQL Server Programming