Timeline for Disabling variable substitution inside SQLCMD script when using :r syntax
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 4, 2016 at 19:57 | history | edited | Paul White♦ | CC BY-SA 3.0 |
Incorporated comment
|
| Mar 4, 2016 at 18:45 | review | Close votes | |||
| Mar 4, 2016 at 19:57 | |||||
| Mar 4, 2016 at 17:54 | answer | added | wBob | timeline score: 3 | |
| Sep 16, 2015 at 21:20 | answer | added | mskinner | timeline score: 3 | |
| Sep 16, 2015 at 20:54 | comment | added | msgisme | I want to run Script1.sql, Script2.sql, etc... without variable substitution. | |
| Sep 16, 2015 at 19:58 | comment | added | mskinner | I don't completely understand what you are trying to do. Obviously you have a directory $(scriptpath) that contains a bunch of scripts that you want to run for deployment of SQL Agent Jobs. If you disable the variable substitution then SQLCMD won't know where to go to run these files. What is the end result you are looking to accomplish? | |
| Sep 16, 2015 at 16:15 | history | asked | msgisme | CC BY-SA 3.0 |