Just starting to learn it . . .

[joe]

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'.

Suggestions?

[Erland Sommarskog]

(jo*@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, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp