Incorrect syntax parsing :setvar in SQLCMD mode

Question

I downloaded an AdventureWorks 2012 LT Script from CodeProject, but when I try to run it it says:

Incorrect syntax was encountered while parsing :setvar.

There's nothing more than this:

:setvar SqlSamplesDatabasePath   "C:\Program Files\...\DATA\";
:setvar SqlSamplesSourceDataPath "C:\Samples\...\";

And yes, I set the SQLCMD mode on.

score 3 · Accepted Answer · answered Jul 21 '13 at 14:05

3

Yes, don't put semi-colons at the end of any SQLCMD lines; this is not T-SQL and is subject to different parser / interpreter rules and syntax.

:setvar SqlSamplesDatabasePath   "C:\...\"
:setvar SqlSamplesSourceDataPath "C:\...\"
------------------------------------------^

answered Jul 21 '13 at 14:05

Aaron Bertrand

1

Thanks. I fell foul of this too. Surprisingly, these semicolons are in Microsoft's distribution of AdventureWorks LT 2012 on http://msftdbprodsamples.codeplex.com/ : Well, they got that one wrong, didn't they! – Phil Factor Feb 19 '15 at 15:38

1 Answers1