新建 存储过程时报错

Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.

 

将存储过程的头部修改了一下：

USE [css2]
GO
/****** Object:  StoredProcedure [dbo].[sp_order_exchange_css2]    Script Date: 09/05/2012 13:43:02 ******/
SET ANSI_NULLS OFF              // 改为 SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

转载于:https://www.cnblogs.com/withoutaword/archive/2012/09/05/2671902.html