创建storeprocedure时自动生成的查询有什么用？ [英] what is the use of automatic generated queries while creating storeprocedure?

问题描述

Hii，



当我们创建任何商店程序时..

Hii,

when we create any storeprocedure ..

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

这些是少数自动生成的语句..这有什么用途..是否需要进一步保持和预防，或者我们应该只清除所有文本和从create procedure语句开始？

these are few automatated generated statements .. what is the use of this .. is it required to keep and preoceed further or should we just clear all the text and start from create procedure statement ?

推荐答案

用Google搜索？ :(

SET ANSI_NULLS [ ^ ]& SET QUOTED_IDENTIFIER [ ^ ]

Googled? :(
SET ANSI_NULLS[^] & SET QUOTED_IDENTIFIER[^]

从以下链接中读取： -

http://technet.microsoft.com/en-us/library/ms188048.aspx [ ^ ]

http://technet.microsoft.com/en-us/library/ms174393.aspx [ ^ ]

read from below links:-
http://technet.microsoft.com/en-us/library/ms188048.aspx[^]
http://technet.microsoft.com/en-us/library/ms174393.aspx[^]

这篇关于创建storeprocedure时自动生成的查询有什么用？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！