Working with the Transact-SQL Debugger
Transact-SQL is a rich and powerful programming language designed to be used on databases. Visual Basic programmers appreciate the debugging features of this popular language, and for SQL Server–stored procedures they benefit from a Transact-SQL debugger add-in. However, some SQL Server programmers don't use Visual Studio and they would appreciate having a full-featured Transact-SQL debugger to test the execution of stored procedures, triggers, and user-defined functions. This new version of SQL Query Analyzer integrates a Transact-SQL debugger.
To test how Transact-SQL Debugger works, create a user-defined function and a stored procedure as in Listing B.4.
Code Listing B.4. The User-Defined Function and ...
Get Microsoft® SQL Server™ 2000 Programming by Example 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.
