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.

Aaron Bertrand · Accepted Answer · 2013-07-21 14:05:04Z

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, 2013 at 14:05

Aaron Bertrand

282k37 gold badges469 silver badges468 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Phil Factor Over a year ago

Thanks. I fell foul of this too. Surprisingly, these semicolons are in Microsoft's distribution of AdventureWorks LT 2012 on msftdbprodsamples.codeplex.com : Well, they got that one wrong, didn't they!

Collectives™ on Stack Overflow

Incorrect syntax parsing :setvar in SQLCMD mode

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related