SQL存储过程中的NOCOUNT是什么? [英] What is NOCOUNT in SQL stored Procedure?

问题描述

亲爱的朋友，

每当我们在sql服务器数据库中创建一个新的存储过程时，默认情况下都会出现一种格式，其中会写入一条语句:-

Dear Friends,

Whenever we make a new stored procedure in sql server database then by default a format comes in which a statement is written:-

SET NOCOUNT ON

这是什么意思?

谢谢

What do we mean by this?

Thanks

推荐答案

你好朋友，

通过此链接:
http://msdn.microsoft.com/en-us/library/ms189837.aspx [ ^ ]

希望对您有帮助.
如果有帮助，请不要忘记将其标记为答案. :)

hello friend,

go through this link :
http://msdn.microsoft.com/en-us/library/ms189837.aspx[^]

Hope this will help you.
Don''t forget to mark as answer if it helps. :)

将此设置为ON会停止返回返回受影响行结果的消息.
参见
http://msdn.microsoft.com/en-us/library/ms189837.aspx [ ^ ]

将其设置为开"实际上可以提高性能 [ ^ ].

Setting this to ON stops the message that returns the result of rows affected.
See
http://msdn.microsoft.com/en-us/library/ms189837.aspx[^]

Setting this to ON can actually improve performance[^].

这篇关于SQL存储过程中的NOCOUNT是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！