This documentation is archived and is not being maintained.

SQL Object Debugging Using the Locals and Watch Windows

This topic applies to:

Visual Studio Edition

Visual Basic

C#

C++

J#

Web Dev

Express

No

No

No

No

No

Standard

No

No

No

No

No

Pro/Team

Yes

Yes

Yes

Yes

Yes

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.

    NoteNote

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

See Also

Show: