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.