11.8. Extended Stored Procedures (XPs)
The advent of .NET in SQL Server has really changed the area ofextended stored procedures. These used to be the bread and butter of the "hardcore" code scenarios, useful when you hit those times where basic T-SQL and theother features of SQL Server just wouldn't give you what you needed.
With the advent of .NET to deal with things like O/S file accessand other external communication or complex formulas, the day of the XP wouldseem to be waning. XPs still have their teeny tiny place in the world for timeswhere performance is so critical that you want the code running genuinely inprocess to SQL Server, but this is truly a radical approach in the .NETera.
Get Professional SQL Server™ 2005 Programming 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.
