What’s New in Creating and Managing Stored Procedures
Unlike SQL Server 2005 with its addition of .NET CLR stored procedures, SQL Server 2008 doesn’t introduce any significant changes to the creation and functionality of stored procedures. However, one of the most welcome enhancements is the return of the Transact-SQL (T-SQL) debugger to SQL Server Management Studio (SSMS). System administrators can now debug stored procedures without having to install Visual Studio (VS). An introduction to debugging stored procedures is provided later in this chapter in the section “Debugging Stored Procedures Using SQL Server Management Studio.”
One small enhancement to the functionality of stored procedures in SQL Server 2008 is the capability to use table-valued ...
Get Microsoft® SQL Server 2008 R2 Unleashed 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.
