Home Dashboard Directory Help
Search

SSMS 2008 Intellisense reports Invalid Column Name with text in double quotes and SET QUOTED IDENTIFIER off by 509Geronimo


Status: 

Closed
 as Won't Fix Help for as Won't Fix


1
0
Sign in
to vote
Type: Bug
ID: 513941
Opened: 11/24/2009 9:22:22 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

I upgraded from SQL 2005 Express to SQL 2008 Express (SP1). I have T-SQL code with a field value in double quotes (see ex. below). With ANSI SET QUOTED IDENTIFIER off and Intellisense enabled, I still get the double-quoted field values underlined as errors with the message "Invalid column name". At the very least, the expected behavior is that with SET QUOTED IDENTIFIER off the field value will not be interpreted as a column name.

Ex. SELECT "text_" = "<xwidget section='HeadingSection' value='Codes' />"

FYI - the result set is being processed by an HTML template-style DLL that renders web pages from the SQL results.
Details
Sign in to post a comment.
Posted by Microsoft on 12/28/2009 at 11:36 AM
John,

Thank you very much for the input and feedback. We are currently in the process of investigating this issue and evaluating the impact of the change, in order to try and release a fix for this.

We will keep this thread open and update it once we have additional relevant information.

Thank you again for the great feedback!
Sign in to post a workaround.