| title | Command Window | |
|---|---|---|
| description | Learn how to use the Command Window of the Transact-SQL debugger to run debug commands and to edit commands on the code you are debugging. | |
| titleSuffix | T-SQL debugger | |
| ms.prod | sql | |
| ms.technology | ssms | |
| 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||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDE SQL Server]
Use the Command Window 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.