Question:

Explain SET NOCOUNT ON in T-SQL.

Answer:

Include SET NOCOUNT ON statement into the stored procedures to stop the message indicating the number of rows affected by a T-SQL statement. This can reduce network traffic, because your client will not receive the message indicating the number of rows affected by a T-SQL statement.