What is the use of Set NOCOUNT ON;?

Answer:

By Default When we execute any command it return us the number of record affected. if we don't want to return the number of records affected then we can use Set NOCOUNT ON;