SET NOCOUNT ON --first query SET NOCOUNT OFF --second query
Quote:When SET NOCOUNT is ON, the count (indicating the number of rows affected by a Transact-SQL statement) is not returned. When SET NOCOUNT is OFF, the count is returned.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)