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

總結

以上是生活随笔為你收集整理的新建 存储过程时报错的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。