SQL Server Management Studio - Add SQLCMD mode to the query toolbar - 2/23/2015
One of the great unexplored/underutilized features of SQL Server is SQLCMD mode.
Read all about it: Simple Talk Article
If you use Visual Studio Data Tools, the scripts it produces are in SQLCMD mode. So...
Add SQLCMD mode to the toolbar
- Start SSMS

- Make sure you have a blank query window, which will cause the Query toolbar to be shown, go to the end of the toolbar, and pick customize

- From the menu, select add a command, click [Add Command], pick 'Query' from the left hand categories, and find SQLCMD mode, and add it...

- You can then put it where ever on the toolbar you like, I prefer next to the blue 'Check' mark

Blog ID: 2015 Blog_635602464000000000