Re: Just starting to learn it . . .



(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

.



Relevant Pages

  • Re: Technical questions
    ... >technical difficulties. ... >of lines allowed per query. ... What I have to do is configure the script to be ... >compatible with sql server. ...
    (microsoft.public.sqlserver.mseq)
  • Technical questions
    ... technical difficulties. ... of lines allowed per query. ... What I have to do is configure the script to be ... compatible with sql server. ...
    (microsoft.public.sqlserver.mseq)
  • Re: IS NULL not working in WHERE clause.
    ... is a DW fact table to be used in building Analysis Services cubes. ... The table create script for my smaller one day table is: ... I am running SQL Server 2000 EE. ... QUERY 2: ...
    (microsoft.public.sqlserver.programming)
  • Script error
    ... I´ve done one script where i verify the sql server version ... but if i comment the query the script runs without any ...
    (microsoft.public.sqlserver.server)
  • Just starting to learn it . . .
    ... 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 ... Prev by Date: ...
    (comp.databases.ms-sqlserver)