O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required