How Extended Stored Procedures Work

Extended stored procedures enable you to add extremely powerful functionality to your SQL Server. These types of procedures are written by using C or C++ and then compiled into dynamic link libraries (DLLs) . A DLL is a type of executable that can be called on and used by another application. The DLL that makes up the functionality of the extended stored procedure is registered with the SQL Server and then can be called on, as with any normal SQL Server stored procedure. Users can pass parameters into extended stored procedures and receive data back from them as with any other stored procedures.

SQL Server dynamically loads and executes the code in extended stored procedures when they are called. This code ...

Get Writing Stored Procedures for Microsoft SQL Server now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.