The Transact-SQL debugger in SQL Server Management Studio enables you to step through Transact-SQL scripts, stored procedures, triggers, and functions as they are running. The Transact-SQL debugger allows you to do the following:
Step through the Transact-SQL statements in the Query Editor line by line or set breakpoints to stop at specific lines.
Step into or over Transact-SQL stored procedures, functions, or triggers run by the code in the Query Editor window.
Watch the values assigned ...