Hi All,
I'm using a XML Value() method to parse a XML data & insert the data into a table. But i'm getting error as follows:
ERROR:
INSERT failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.
Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications
and/or xml data type methods.
Here's the code snippet for your reference (part of an Stored Proc in SIT box):
.
.
.
SET QUOTED_IDENTIFIER OFF
INSERT INTO Employee(EmpNo, EName)
SELECT XMLColumn.value('(row/@EmpId)[1]', 'INT') AS EmpNo,
XMLColumn.value('(row/@EmpName)[1]', 'CHAR(60)') AS EmpName
FROM XMLTable
SET QUOTED_IDENTIFIER ON
.
.
.
Does QUOTED IDENTIFIER get affected inside the SP... Or do i need to change the setting in my DB?
Note: I'm not getting any error in my DEV box which has Quoted Identifier Enabled = False... Even in my SIT box, it's set to False.
Any help in this issue is highly appreciated.
Thanks in advance 🙂