SQL Object Debugging Using the Locals and Watch Windows
This topic applies to:
Edition |
Visual Basic |
C# |
C++ |
Web Developer |
|---|---|---|---|---|
Express |
.gif "Topic does not apply") |
|
|
|
Standard |
|
|
|
|
Pro and Team |
.gif "Topic applies") |
|
|
|
Table legend:
|
Applies |
|
Does not apply |
.gif "Topic applies but command hidden by default") |
Command or commands hidden by default. |
The following describe the Locals and Watch windows, two debugger windows you can use while debugging a SQL object.debugger.
You can edit the values of the variables in the Locals and Watch windows as the SQL object runs. However, to change the value of a char, nchar, varchar or nvarchar field inside a database object written in T-SQL, do not enclose the string in quotation marks. Enclose strings in quotation marks for SQL common language runtime (CLR) objects.
In SQL objects, you can set expressions in the Watch window, but you cannot set such expressions in a T-SQL object.
Note
The server may not reflect changes to values of variables in the debugger windows. For more information, see SQL Debugging Limitations.
See Also
Tasks
How to: Use Debugger Variable Windows
Concepts
Limitations on Debugger Commands and Features