Skip to Content
Author's profile photo Former Member

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 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.



Marcelo Silva Santos

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.