我有一存储过程,在查询分析器里执行没有错误,可是放到程序里,程序就会出错并提示:
'Delete'失败,因为下列 SET 选项设置不正确:'ARITHABORT'
可是我在存储过程中已经设置,如下:
CREATE procedure CombineInArrearageList
as
SET nocount ON
SET ARITHABORT ON
SET ARITHIGNORE ON
SET ANSI_WARNINGS ON
请问该如何解决??
...全文
575打赏收藏
谁遇到过这样的问题?
我有一存储过程,在查询分析器里执行没有错误,可是放到程序里,程序就会出错并提示: 'Delete'失败,因为下列 SET 选项设置不正确:'ARITHABORT' 可是我在存储过程中已经设置,如下: CREATE procedure CombineInArrearageList as SET nocount ON SET ARITHABORT ON SET ARITHIGNORE ON SET ANSI_WARNINGS ON 请问该如何解决??
SET nocount ON
SET ARITHABORT ON
SET ARITHIGNORE ON
SET ANSI_WARNINGS ON
set nocount off
SET ARITHABORT off
SET ARITHIGNORE off
SET ANSI_WARNINGS off
试试看了