开发者

SQL Server Management Studio problem creating scripts of procedures

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜