还是不行,我加了SET ARITHABORT ON 和 SET ARITHIGNORE ON ,代码如下:可是当我保存了存储过程后,再打开这个存储过程进行编辑时 ,发现 SET ARITHABORT ON 和 SET ARITHIGNORE ON 这两行代码又不见了,奇怪???SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO SET ARITHABORT ON SET ARITHIGNORE ONALTER PROCEDURE [dbo].[pro_InsertScjh] @JhrwNo char(10), @ManufactureNo char(10), @JhCount float, @JhDepartmentNo char(10), @ProducePl float, @DepartmentNo char(10), @StartWorkDate datetime, @EndWorkDate datetime ASinsert into tbl_scjh (JhrwNo,ManufactureNo,JhCount,JhDepartmentNo, ProducePl,DepartmentNo,StartWorkDate,EndWorkDate) values (@JhrwNo,@ManufactureNo,@JhCount,@JhDepartmentNo, @ProducePl,@DepartmentNo,@StartWorkDate,@EndWorkDate)GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO
GO
SET ANSI_NULLS ON
GO
SET ARITHABORT ON
SET ARITHIGNORE ONALTER PROCEDURE [dbo].[pro_InsertScjh]
@JhrwNo char(10),
@ManufactureNo char(10),
@JhCount float,
@JhDepartmentNo char(10),
@ProducePl float,
@DepartmentNo char(10),
@StartWorkDate datetime,
@EndWorkDate datetime
ASinsert into tbl_scjh
(JhrwNo,ManufactureNo,JhCount,JhDepartmentNo,
ProducePl,DepartmentNo,StartWorkDate,EndWorkDate)
values (@JhrwNo,@ManufactureNo,@JhCount,@JhDepartmentNo,
@ProducePl,@DepartmentNo,@StartWorkDate,@EndWorkDate)GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO