询问者
About index for computed column

问题
-
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