开发者

SQL Server Management Studio problem creating scripts of procedures

开发者 https://www.devze.com 2023-01-16 06:52 出处:网络
The stored procedure scripts that SQL Server Management Studio 2005 generates for me are like: SET ANSI_NULLS ON

The stored procedure scripts that SQL Server Management Studio 2005 generates for me are like:

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[APY_SP_ACH_Transmit_Finish]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
  ...
  print ''arg!, all the quotes are escaped''
  ...
 '
END

so all the quotes are escaped. is there a way or o开发者_开发知识库ption to turn this off?

in SQL Server Management Studio 2005. I do the following:

1) In Object Explorer, locate the procedure I want to script out

2) right click, and select script stored procedure as "Create To"

3) selecting file or clipboard has the same effect.


This seems to happen when the scripting option "Include If NOT EXISTS" clause is on.

Do you need this on? If not you can turn it off via the

Tools -> Options -> Scripting

From this Connect item it doesn't look configurable without that.

0

精彩评论

暂无评论...
验证码 换一张
取 消