posted by 네코냥이 2014. 1. 3. 12:22

Does SET NOCOUNT ON eliminate @@ROWCOUNT values after table inserts?



Nope, SET NOCOUNT doesn't interfere with @@ROWCOUNT.

SET NOCOUNT is used to control message returned SQL server to client , it is not just for inserts alone, even for other DML statements as well.