SQL Server - Set Nocount On

SQL Server - Set Nocount On      
   
when you use the "set nocount on" sql server will not count how many row are effecting. that way it's imporve the performance of query of stored procedure.
Example 1:

set nocount on
 

select * from User_Details

Result: Command(s) completed successfully.

Example 2:

set nocount Off

 select * from User_Details 

Result : (12 row(s) affected)





I hope it will help you