Skip to content

transact-sql-debugger-watch-window.md

Latest commit

 

History

History
67 lines (47 loc) · 3.25 KB

transact-sql-debugger-watch-window.md

File metadata and controls

67 lines (47 loc) · 3.25 KB
title Watch Window
description Learn about Watch windows (as many as four at once), which display information about expressions you select. The information displays only in debug mode.
titleSuffix T-SQL Debugger
ms.prod sql
ms.technology ssms
ms.topic conceptual
helpviewer_keywords
Watch Window [Transact-SQL]
ms.assetid 23f3baa4-14c2-4262-92f7-3f43fcfa0436
author markingmyname
ms.author maghan
ms.custom seo-lt-2019
ms.reviewer
ms.date 12/04/2019
monikerRange >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

Transact-SQL Debugger - Watch Window

[!INCLUDE SQL Server]

The Watch window displays information about the expressions that you have selected. There can be up to four watch windows: Watch 1, Watch 2, Watch 3, and Watch 4. The expressions are evaluated within the scope of the current call stack frame that is selected in the Call Stack window. You must be in debug mode to watch variables and expressions.

[!INCLUDEssms-old-versions]

Task List

To access the Watch windows

  • On the Debug menu, click Windows, click Watch, and then click Watch 1, Watch 2, Watch 3, or Watch 4.

To change the value of an expression

  • Right-click the expression, and then select Edit Value.

Columns

Name
Are the expressions that are listed by the [!INCLUDEtsql] debugger. The following expressions are supported:

  • Variables.

  • Parameters.

  • System functions whose name starts with @@.

  • Expressions built by applying operators to one or more variables, parameters, or system functions, such as @IntegerCounter + 1, or FirstName + LastName.

  • Transact-SQL statements that return a single value, such as: SELECT CharacterCol FROM MyTable WHERE PrimaryKey = 1.

Value
Displays the value that is returned after the [!INCLUDEtsql] debugger evaluates the expression specified in Name.

If the length of an expression is larger than the width of the Value column, a tooltip displays the full value when you move the pointer over the Value cell for that expression.

A magnifying glass icon in a Value cell indicates that the [!INCLUDEtsql] debugger visualizer is available. In the list, you can specify Text Visualizer, XML Visualizer, or HTML Visualizer. To start a debugger visualizer, click the magnifying glass icon. The [!INCLUDEtsql] debugger opens a dialog that displays the data in a format appropriate to the data type.

Type
Displays the data type of the expression.

See Also

Transact-SQL Debugger
Transact-SQL Debugger Information
Locals Window
Call Stack Window
QuickWatch Dialog Box
Expressions (Transact-SQL)