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”

USE $(DatabaseName);

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.

References:

http://blogs.msdn.com/b/sql_server_appendix_z/archive/2013/02/23/sql-server-management-studio-sqlcmd-meets-the-richter-scale.aspx

http://blog.sqlauthority.com/2013/06/28/sql-server-how-to-set-variable-and-use-variable-in-sqlcmd-mode

http://msdn.microsoft.com/en-us/library/ms188714.aspx

Regards,

Marcelo Silva Santos