Post reply

invalid syntax

  • January 27, 2006 at 5:52 am

    #170310

    i have sql server 2000.

    i have a table dump(id,image)

    id is of varchar datatype.

    image is of image dataype

    i have a query

    INSERT INTO dump(id,image) VALUES(?,?)

    i compiled this in the SQL query analyzer compiler.

    this throws "incorrect syntax near the keyword dump"...

    what does it mean ?

    whats wrong in this query ?

  • January 27, 2006 at 6:23 am

    #617439

    dump is a keyword. Note the color is blue in Query Analyser.

    try :

    INSERT INTO [dump](id,image)

  • January 30, 2006 at 6:19 am

    #617695

    thank you.

    this works fine....you are great.

    but, you told

    dump is a keyword. Note the color is blue in Query Analyser.

    my my SQL server 2000 Query analyser is not showing any blue color !!

    i just copied and pasted the query on the query analyser and clicked for the compilation.

    there is no blue color!

    why there is no syntax highlighting ?

  • January 30, 2006 at 11:02 am

    #617781

    maybe someone changed the settings in QA....go to "Tools"..."Options"...."Fonts" tab and check to see what the settings are for "Keyword"...set the "Foreground" to blue...







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply