O'Reilly logo

Writing Stored Procedures for Microsoft SQL Server by Matthew Shepker

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required