Rajesh

• Dec 14th, 2006

 

The Microsoft Extended Stored Procedure API provides a server-based application programming interface (API) for extending Microsoft SQL Server 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.

Shayer

• Dec 20th, 2006

 

Extended Stored procedure is a function in a DLL that can be called from T-SQL in a similar manner as we call normal stored procedure.Can accept parameter and return value as well.