I am trying to pass a parameter into a sqlcmd something like this. The following is a part of the batch job.
sqlcmd -S ServerName -d db /U sa /P sa /i E:SQLTest.sql %1 -o E:\test.txt
and have the sqltest.sql is an update statement similiar to this
SET Status = 'Finished'
where JobName = '%1'
I need the %1 to update to a different value as the batch is run.
Does anyone know how to accomplish?