January 27, 2006 at 5:52 am
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
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
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
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