Administration & ToolsSQLCMD mode in SSMSSQLCMD mode in SSMSHere are some commands very useful. Things help to deploy complicated queries. 1 2 3 4 5 6 7 8 9 10 11 12 13 :CONNECT localhost :setvar DBA "DBA" :on error exit GO USE [$(DBA)] go SELECT DB_NAME() print 'abc.sql -- Simon' :r c:\temp\abc.sql GO print 'abcdef.sql -- Simon' :r c:\temp\abcdef.sql GO