sql – 因为arithabort配置不正确而失败

我建设了一个独一索引(假如IsDelete！= 1,则案例描写应该是独一的)

CREATE UNIQUE NONCLUSTERED INDEX [UniqueCaseDescription]
ON [tblCases] ([fldCaseDescription] ASC) 
WHERE [IsDeleted] = CAST(0 AS varbinary(1))
WITH (PAD_INDEX  = OFF,STATISTICS_NORECOMPUTE  = OFF,SORT_IN_TEMPDB = OFF,IGNORE_DUP_KEY = OFF,DROP_EXISTING = OFF,ONLINE = OFF,ALLOW_ROW_LOCKS  = ON,ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

然后,当我运行以下进程时,它会抛出’UPDATE失败,由于以下SET选项具有不正确的配置：’ARITHABORT’.验证SET选项是否正确用于过滤索引.

ALTER PROC [usp_DeleteCase] (@fldCaseID UNIQUEIDENTIFIER)
AS
BEGIN   
    UPDATE tblCases
    SET IsDeleted = 1
    WHERE fldCaseID = @fldCaseID

    RETURN 1
END

我实行在UPDATE语句之前添加SET ARITHABORT ON,可是没有做任何工作.

任何辅佐是极大的赞赏！

办理要领

1)打开SQL Server Management Studio.
2)右键单击您行使的数据库名称,然后选择属性>选项菜单.然后从打开的对话框中配置Arithmetic abort enabled = True.

留意：我还实行行使剧本应用沟通的配置,但通过SSMS行使此要领最好应用此配置.

但愿这可以辅佐…

（编辑：湖南网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!