Friday, September 10, 2010

What's the use of SET NOCOUNT ON

What's the use of SET NOCOUNT ON?

SET NOCOUNT ON eliminates the sending of the messages to the client for each statement in a stored procedure, like "10 row(s) effected" if you select or update data. For example when SET NOCOUNT is OFF or nothing defined it will shows like below below Image.
 
When SET NOCOUNT is ON, the count will not be returned back to client.

The @@ROWCOUNT function is updated even when SET NOCOUNT is ON. When SET NOCOUNT is OFF, the count is returned. 

NOTE: The setting of SET NOCOUNT is set at execute or run time and not at parse time.
SET NOCOUNT Transact-SQL. SET NOCOUNT. Effect of SET NOCOUNT ON. SET NOCOUNT ON usage. A simple Performance Booster in sql server. What is the use of SET NOCOUNT ON in SQL Server. what happen when we ON set no count. set nocount on in sql server 2008. set nocount on in sql server 2012. set nocount on stored procedure. set nocount on means. set nocount on in oracle. set nocount on in sql. set nocount on in sybase. set nocount on and off. set nocount on in sql server.

0 comments:

Post a Comment