Parameterized query fails syntax check when comments exist

#1

I am wanting to pass a global varible into a simple insert..select statement
contained in an execute SQL task. The existing code has comments in the
header. The query will not pass a syntax check if the comments exist. I
treid both forms of comments, -- and /* to no avail. Removing the comments
allows the statement to pass and function.

Known problem? Any fix?

TIA,

Jeff

#2

It's a known problem. Try writing your comments after your SQL statement.

Francesco Anti

"Jeffrey K. Ericson" <JeffreyKEricson (AT) discussions (DOT) microsoft.com> wrote in
message news:B42BC8D4-304E-4C06-875C-7E87389FF732 (AT) microsoft (DOT) com...

Quote:

I am wanting to pass a global varible into a simple insert..select
statement
contained in an execute SQL task. The existing code has comments in the
header. The query will not pass a syntax check if the comments exist. I
treid both forms of comments, -- and /* to no avail. Removing the
comments
allows the statement to pass and function.

Known problem? Any fix?

TIA,

Jeff

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Parameterized query fails syntax check when comments exist

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Parameterized query fails syntax check when comments exist - 04-20-2005 , 10:21 AM

Re: Parameterized query fails syntax check when comments exist - 04-20-2005 , 10:31 AM