Skip to content

Latest commit

 

History

History
43 lines (32 loc) · 1.89 KB

File metadata and controls

43 lines (32 loc) · 1.89 KB
title Command Window | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql
ms.technology scripting
ms.reviewer
ms.topic conceptual
f1_keywords
VS.CommandWindow
helpviewer_keywords
Command Window [Transact-SQL]
ms.assetid e567ebf9-0793-451b-92c7-26193a02d9da
author stevestein
ms.author sstein
manager craigg
monikerRange >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

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