Timeline for Setting variables in SQLCMD mode
Current License: CC BY-SA 3.0
8 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Jun 22, 2015 at 18:28 | comment | added | Tim Abell | What you ask for is not possible per-se, because sqlcmd variables are evaluated by the client before the sql is ever sent to the server. So you are asking for the sql server to set the value of a variable that it never sees. Run a sql profiler trace on a sql script with sqlcmd variables and you'll see they have all already been evaluated. | |
Jul 18, 2013 at 9:13 | vote | accept | Craig Efrein | ||
Jul 15, 2013 at 7:29 | history | edited | Craig Efrein | CC BY-SA 3.0 |
added 676 characters in body
|
Jul 12, 2013 at 17:10 | history | tweeted | twitter.com/#!/StackDBAs/status/355735808629673984 | ||
Jul 12, 2013 at 14:19 | answer | added | SQLRockstar | timeline score: 10 | |
Jul 12, 2013 at 12:56 | comment | added | user507 | Not that I am aware of, or could figure out. | |
Jul 12, 2013 at 12:49 | history | edited | user507 |
edited tags
|
|
Jul 12, 2013 at 12:04 | history | asked | Craig Efrein | CC BY-SA 3.0 |