I have an example.sql file, that has 1 parameter
FROM OPENROWSET (BULK '$(filePath)', SINGLE_CLOB) AS j
And I wanna run it in sqlcmd mode.
:setvar path "C:Path_to_scripts" :setvar filePath "Path" :r $(path)example.sql
How can I pass the filePath to the sql file.
This question is not yet answered, be the first one who answer using the comment. Later the confirmed answer will be published as the solution.