Skip to content

transact-sql-debugger-locals-window.md

Latest commit

 

History

History
62 lines (50 loc) · 3.06 KB

transact-sql-debugger-locals-window.md

File metadata and controls

62 lines (50 loc) · 3.06 KB

title: "Locals Window | Microsoft Docs" ms.custom: "" ms.date: "03/14/2017" ms.prod: "sql" ms.prod_service: "sql-tools" ms.service: "" ms.component: "ssms-scripting" ms.reviewer: "" ms.suite: "sql" ms.technology:

  • "database-engine" ms.tgt_pltfrm: "" ms.topic: "article" f1_keywords:
  • "vs.debug.locals" helpviewer_keywords:
  • "Locals Window [Transact-SQL]" ms.assetid: 59bea640-7823-4b4d-832c-f384d83cca2f caps.latest.revision: 16 author: "MightyPen" ms.author: "genemi" manager: "craigg" ms.workload: "Inactive" monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"

Transact-SQL Debugger - Locals Window

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] The Locals window displays information about the local expressions in the current scope of the [!INCLUDEtsql] debugger. The scope is set to the current call stack frame that is selected in the Call Stack window. You must be in debug mode to display the local expressions.

Task List

To access the Locals window

  • On the Debug menu, click Windows, and then click Locals.

To change the value of an expression

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

Columns

Name
Is the name of the local expression. The [!INCLUDEtsql] debugger lists variables, parameters, and the system functions that have names that start with @@.

Value
Displays the value that is currently assigned to the local expression. This column is blank when no value has been assigned to the expression.

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 box 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
Watch Window
Call Stack Window
QuickWatch Dialog Box
Expressions (Transact-SQL)