SET NOCOUNT { ON | OFF }
来源:互联网 发布:win7安装版iso镜像mac 编辑:程序博客网 时间:2024/05/01 08:06
Syntax
SET NOCOUNT { ON | OFF }
Remarks
When SET NOCOUNT is ON, the count is not returned. When SET NOCOUNT is OFF, the count is returned.
The @@ROWCOUNT function is updated even when SET NOCOUNT is ON.
SET NOCOUNT ON prevents the sending of DONE_IN_PROC messages to the client for each statement in a stored procedure. For stored procedures that contain several statements that do not return much actual data, or for procedures that contain Transact-SQL loops, setting SET NOCOUNT to ON can provide a significant performance boost, because network traffic is greatly reduced.
The setting specified by SET NOCOUNT is in effect at execute or run time and not at parse time.
以sp_who为例做下解释:
SET NOCOUNT OFF
EXEC sp_who
SET NOCOUNT ON
EXEC sp_who
可以看出除了返回我们所想要的results的外,SET NOCOUNT OFF,还返回所影响的行数,SET NOCOUNT ON,则只返回SQL执行成功.
这样做的好处:
提高了SQL执行性能,优化项目。
- SET NOCOUNT { ON | OFF }
- SET NOCOUNT ON | OFF
- Set NoCount ON/OFF
- SET NOCOUNT { ON | OFF }
- SET NOCOUNT { ON | OFF }实用讲解
- SET NOCOUNT { ON | OFF }实用讲解
- Sql Server 使用 SET NOCOUNT { ON | OFF}
- SQLServer 存储过程 SET NOCOUNT { ON | OFF } 的使用。
- SQLServer 存储过程 SET NOCOUNT { ON | OFF } 的使用
- SQLServer 存储过程 SET NOCOUNT { ON | OFF } 的使用。
- 存储过程 SET NOCOUNT { ON | OFF }实用讲解
- 存储过程之SET NOCOUNT ON/OFF 含义
- 存储过程中的 SET NOCOUNT ON 和SET NOCOUNT OFF是 什么意思?
- 使用SET NOCOUNT ON
- SET NOCOUNT ON
- 使用 SET NOCOUNT ON
- set nocount on
- SET NOCOUNT ON
- android关于银行卡号的验证算法
- Apktool v2.0.3 Released
- jquery正则图片查找
- NMF(非负矩阵分解)算法
- cJSON代码阅读(1)——JSON介绍
- SET NOCOUNT { ON | OFF }
- 解决AsyncTask,doingBackground方法未及时执行
- js css 压缩混淆
- WSDL文件详解
- Opencv2.4.9源码分析——HoughCircles
- linux c加密和解密的例子
- 尝试在让script的type属性等于text/html
- MySql中添加用户,新建数据库,用户授权,删除用户,修改密码
- 解决Xcode7多个模拟器的方法