How to do a sql server equivalent of Oracle 'set feedback on'
I haven’t been able to find a T-sql equivalent of the Oracle ‘set feedback on’, which outputs a line telling you how many rows have been effected by the last sql statement.
The closest thing, I think, is:
select 'Rows updated: ' + CAST(@@ROWCOUNT as varchar(10))