I have say couple of sql files which needs to be executed on batch of database (variable).
For sql files - i will keep this files in one local folder.
For database (variable) - i will keep the information about dbs and their server in one txt file.
Variable - Different databases from different servers.
Now i want to create one batch file i.e *.bat which will execute 'sqlcmd' picking up *.sql files from folder and database information from the txt file.
How can i achieve this ?
Note: I would not like to use 'SET' command.