About index for computed column

Question

I try to create a index for a computed column,but the client reply the program throw out a error:

insert failed because the following set options have incorrect:QUOTED_IDENTIFIER,please make sure the SET options is enabled fro the computed column

I'm a chinese, and it is my first time to join this forum, I apologise for my poor English

use code:

ALTER TABLE Box_M ADD hash_title AS CHECKSUM(replace(Ship_No,'$',''));-- create the  computed column

GO
set NUMERIC_ROUNDABORT Off
GO
set ANSI_NULLS  on
GO
set ANSI_PADDING on
GO
set ANSI_WARNINGS on
GO
set ARITHABORT on
GO
set CONCAT_NULL_YIELDS_NULL on
GO
set QUOTED_IDENTIFIER ON
GO
create INDEX hash_index ON Box_M(hash_title);
GO

Answer 1

是部分insert出错还是都出错？ 我简单试了下，没有报错。我不确定是否需要持久化这个列。

Answer 2

Did you set same options when create computed column? 

Answer 3

你好，

请问在你create Box_M table 时，有没有设置过QUOTED_IDENTIFIER 的值呢 ？如果方便的话，请贴上整个查询语句。

Thanks.

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.

Answer 4

从错误提示看，应该是跟你的插入语句相关，跟表结构没有关系，确定一下你做 INSERT 时的语句和 QUOTED IDENTIFIER 设置

（联机帮助上有说明，创建表时，即使此时将 QUOTED IDENTIFIER 选项设置为 OFF，该选项在表的元数据中仍始终存储为 ON。所以这个问题应该是在 INSERT 语句操作时，QUOTED IDENTIFIER 为 OFF 导致的问题）