SQL Server Home
SSMS 2008 Intellisense reports Invalid Column Name with text in double quotes and SET QUOTED IDENTIFIER off
as Won't Fix
11/24/2009 9:22:22 AM
User(s) can reproduce this bug
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.
SQL Server 2008 - Express Edition
Windows XP Professional
Operating System Language
Steps to Reproduce
Run SSMS 2008 Express with ANSI SET QUOTED IDENTIFIER off and Intellisense enabled.
Paste the following into a new query window and wait while Intellisense parses it: SELECT "text_" = "<xwidget section='HeadingSection' value='Codes' />"
The field value "<xwidget section='HeadingSection' value='Codes' />" is underlined in red with a tooltip error message saying "Invalid column name ...".
The field value is not flagged in error.
to post a comment.
Please enter a comment.
on 12/28/2009 at 11:36 AM
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!
to post a workaround.
Please enter a workaround.
© 2014 Microsoft