Skip to content

Latest commit

 

History

History
51 lines (40 loc) · 2.08 KB

File metadata and controls

51 lines (40 loc) · 2.08 KB

title: "Command 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.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" ms.workload: "Inactive" monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"

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