SQL SERVER – How to Set Variable and Use Variable in SQLCMD Mode
Enable sqlcmd mode in SQL Server Management Studio as described in following image.
Now in query editor type following SQL.
:SETVAR DatabaseName “SBOPRODIR”
:SETVAR SchemaName “dbo”
:SETVAR TableName “OITM”
SELECT * FROM $(SchemaName).$(TableName);
Note that I have set the value of the database, schema and table as a sqlcmd variable and I am executing the query using the same parameters.
SQLCMD is a relatively simple language to master and it also aids in doing various tasks easily.
Marcelo Silva Santos