把存储过程删掉重建试试SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
GO CREATE PROCEDURE .... GOSET ANSI_NULLS OFF
SET ANSI_WARNINGS OFF
GO
SET ANSI_WARNINGS ON
GO CREATE PROCEDURE .... GOSET ANSI_NULLS OFF
SET ANSI_WARNINGS OFF
GO
SET ANSI_WARNINGS ON
GO CREATE PROCEDURE .... GOSET ANSI_NULLS OFF
SET ANSI_WARNINGS OFF
GO
结贴!