| title | Command Window | |
|---|---|---|
| titleSuffix | T-SQL debugger | |
| ms.prod | sql | |
| ms.technology | scripting | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | e567ebf9-0793-451b-92c7-26193a02d9da | |
| author | markingmyname | |
| ms.author | maghan | |
| ms.reviewer | ||
| ms.custom | seo-lt-2019 | |
| ms.date | 12/04/2019 | |
| monikerRange | >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-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.
[!INCLUDEssms-old-versions]
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.