Edit

Stored Procedures in SQL Server Native Client

  • Article

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

Important

The SQL Server Native Client (often abbreviated SNAC) has been removed from SQL Server 2022 (16.x) and SQL Server Management Studio 19 (SSMS). Both the SQL Server Native Client OLE DB provider (SQLNCLI or SQLNCLI11) and the legacy Microsoft OLE DB Provider for SQL Server (SQLOLEDB) are not recommended for new development. Switch to the new Microsoft OLE DB Driver (MSOLEDBSQL) for SQL Server going forward.

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

See Also

SQL Server Native Client (OLE DB)