| Erland Sommarskog 2005-08-22, 8:23 pm |
| (joe@joeschweighofer
.com) writes:
> I can't get a script to run that's supposed to generate a Query
> Parameters dialogue to take inputs and then run the query - for
> example, the following
>
> . . .
> and fl.flow_name = [[TRUE][FLOW NAME][@?]]
> . . .
>
> generates SQL Query Analyzer exceptions about "Incorrect syntax near
> 'FLOW NAME'.
I have no idea what that is supposed to mean. You get a syntax error
because first you have an identifier [TRUE. This is followed by another
identifier FLOW NAME, and this is not legal synax. Next follows
quoted identifier which lacks a closing quote - the two ]] means
a single ] is part of the idenfier.
Or in summary, the above is gibberish as far as SQL Server is concerned.
Since you can't run dialogues in Query Analyzer anyway, I suspect that
the script is intended to be run from somewhere else, although I have
no idea from where.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
|