CODE EXAMPLE FOR SQL

STOP message of how many rows affected sql

--Start counting messages and show number of rows affected
SET NOCOUNT OFF
--Stop counting messages and do not show number of rows affected
SET NOCOUNT ON