-- Use the SET NOCOUNT ON statement as the first statement in the body of the procedure. That is, place it just after the AS keyword. This turns off messages that [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] sends back to the client after any SELECT, INSERT, UPDATE, MERGE, and DELETE statements are executed. This keeps the output generated to a minumum for clarity. There is no measurable performance benefit however on todays hardware. For information, see [SET NOCOUNT (Transact-SQL)](../../t-sql/statements/set-nocount-transact-sql.md).
0 commit comments