Skip to content

Latest commit

 

History

History
46 lines (35 loc) · 1.97 KB

File metadata and controls

46 lines (35 loc) · 1.97 KB

title: "Command Window | Microsoft Docs" ms.custom: "" ms.date: "03/14/2017" ms.prod: sql ms.technology: scripting ms.reviewer: "" ms.suite: "sql" ms.tgt_pltfrm: "" ms.topic: conceptual f1_keywords:

  • "VS.CommandWindow" helpviewer_keywords:
  • "Command Window [Transact-SQL]" ms.assetid: e567ebf9-0793-451b-92c7-26193a02d9da caps.latest.revision: 14 author: MightyPen ms.author: genemi manager: craigg monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017"

Transact-SQL Debugger - Command Window

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] Use the CommandWindow to run commands, such as debug and edit commands, against the code in the [!INCLUDEssDEnoversion] Query Editor window that is currently being debugged. You must be in debug mode to use the Command Window. The [!INCLUDEtsql] debugger supports many of the commands that are also supported in the [!INCLUDEmsCoName] [!INCLUDEvsprvs] Command window. For more information, see Visual Studio Command Window.

Task List

To access the Command Window

  • On the Debug menu, click Start Debugging.

To print the value of a variable

  • In the CommandWindow, type Debug.Print <VariableName>, and then press ENTER.

To list information about the current thread

  • In the CommandWindow, type Debug.ListThread, and then press ENTER.

To add a variable to the QuickWatch window

  • In the CommandWindow, type Debug.QuickWatch <VariableName>, and then press ENTER.

See Also

Transact-SQL Debugger