Question

sqlserver中的nocount on 和nocount off到底有什么区别？

Answer 1

insert into t values(1) insert into t values(2)go--设置为off set nocount offgoupdate t set col=1 --在messages栏会返回：(2 row(s) affected)设置为ONset nocount ongoupdate t set col=1 --在messages栏只回返：Command(s) completed successfully. 这个设置不会影响运行结果。 联机帮助里也写明了它的作用: SET NOCOUNT ON prevents the sending of DONE_IN_PROC messages to the client for each statement in a stored procedure. When you are using the utilities provided with SQL Server 2005 to execute queries, the results prevent nn rows affected