Chapter 20. Extended Stored Procedures
Programming in machine code is like eating with a toothpick. The bites are so small and the process so laborious that dinner takes forever.
—Charles Petzold[1]
[1] Petzold, Charles. Code. Redmond, WA: Microsoft Press, 2000. Page 349.
In addition to regular Transact-SQL-based stored procedures, you can also write stored procedures in C, C++, and other languages that can communicate with the ODS API. These types of procedures are known as extended stored procedures, and they receive parameters and return results via the ODS framework. They reside in DLLs and behave similarly to regular stored procedures. You create a reference to them in SQL Server by calling the sp_addextendedproc stored procedure (or through ...
Get Guru's Guide to SQL Server™ Stored Procedures, XML, and HTML, The now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
