SET NOCOUNT ON in Sql server

Please refer this link:

http://dotnetprof.blogspot.in/2012/09/what-is-set-nocount-in-sql.html