SQL SET NOCOUNT ON

The SQL SET NOCOUNT ON and OFF is one set function used to stop the number of rows affected message from a query or Stored Procedure to the client. When you select data from a table, a stored procedure or query will return those records as the result. And it displays the message as Number … Read more