database-engine-extended-stored-procedure-programming.md

title	Database Engine Extended Stored Procedure Programming | Microsoft Docs
ms.custom
ms.date	04/27/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology
ms.topic	reference
helpviewer_keywords	extended stored procedures [SQL Server], programming stored procedures [SQL Server], extended Database Engine [SQL Server], stored procedures macros [SQL Server] Extended Stored Procedure API [SQL Server]
ms.assetid	158a6765-0542-4e84-b5ab-f173d946ef5e
author	MightyPen
ms.author	genemi
manager	craigg

Database Engine Extended Stored Procedure Programming

Important

[!INCLUDEssNoteDepFutureDontUse] Use CLR Integration instead. For more information, see Common Language Runtime (CLR) Integration Programming Concepts.

The [!INCLUDEmsCoName] Extended Stored Procedure API provides a server-based application programming interface (API) for extending [!INCLUDEmsCoName] [!INCLUDEssNoVersion] functionality. The API consists of C and C++ functions and macros used to build applications in the following categories: extended stored procedures and gateway applications.

Extended stored procedures allow you to create your own external routines in a programming language such as C. The extended stored procedures appear to users as typical stored procedures and are executed in the same way. Parameters can be passed to extended stored procedures, and they can return results and return status.

In This Section

Programming Extended Stored Procedures
Explains how to create, manage, and use extended stored procedures.

Extended Stored Procedures Programmer's Reference
Contains reference topics for the Extended Stored Procedure API.