发布时间:2025-12-10 19:54:25 浏览次数:1
出现QUOTED_IDENTIFIER错误[通俗易懂]增加删除都会出现类似下面的这种错误,INSERTfailedbecausethefollowingSEToptionshaveincorrectsettings:'QUOTED_IDENTIFIER'.VerifythatSEToptionsarec
增加删除都会出现类似下面的这种错误,
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 filtered indexes and/or query notifications and/or XML
DELETE 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 filtered indexes and/or query notifications and/or XML
因为表中有一个计算字段:
更改了这后如图之后即可: