Transact-SQL Object Debugging Using the Locals and Watch Windows

This topic applies to:

Visual Studio Ultimate	Visual Studio Premium	Visual Studio Professional	Visual Studio Express

The following describes the Locals and Watch windows, two debugger windows you can use while debugging a Transact-SQL database object:

You can edit the values of the variables in the Locals and Watch windows as the Transact-SQL database object runs. However, to change the value of a char, nchar, varchar or nvarchar field inside a database object written in Transact-SQL, do not enclose the string in quotation marks. Note: Enclose strings in quotation marks for SQL/CLR database objects.
In Transact-SQL database objects, you cannot set expressions in the Watch window.

Note

The server may not reflect changes to values of variables in the debugger windows. For more information, see Transact-SQL Debugging Limitations.

See Also