Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

QUOTED_IDENTIFIER

Status
Not open for further replies.

pmcdaniel

Programmer
Feb 9, 2007
127
US
I read that I can create a dynamic query by setting QUOTED_IDENTIFIER OFF. This is true and I was able to make string values on the fly and it works great!

However, when I tried to turn the query into a Stored Procedure(Create Procedure) I got Error: Invalid column name '''. Is anyone familiar with QUOTED_IDENTIFIER who can tell me if there is anything I can do?

 
I figured it out.... I put SET QUOTED_IDENTIFIER OFF at the very top of the proc before creating it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top