| title | Stored Procedures | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 03/14/2017 | ||||
| ms.prod | sql | ||||
| ms.prod_service | database-engine, sql-database, sql-data-warehouse, pdw | ||||
| ms.reviewer | |||||
| ms.technology | native-client | ||||
| ms.topic | reference | ||||
| helpviewer_keywords |
|
||||
| ms.assetid | 75611e40-789f-412b-91e5-0cc0b8d289ef | ||||
| author | markingmyname | ||||
| ms.author | maghan | ||||
| monikerRange | >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md]
A stored procedure (Stored Procedures (Database Engine)) is an executable object stored in a database. [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] 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.