Re: Just starting to learn it . . .
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Mon, 22 Aug 2005 22:13:30 +0000 (UTC)
(joe@xxxxxxxxxxxxxxxxxxx) 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@xxxxxxxxxxxxx
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
.
- References:
- Just starting to learn it . . .
- From: joe
- Just starting to learn it . . .
- Prev by Date: Just starting to learn it . . .
- Next by Date: dbo qualified name problem w/Access 2003
- Previous by thread: Just starting to learn it . . .
- Next by thread: dbo qualified name problem w/Access 2003
- Index(es):
Relevant Pages
|