Show rows affected
If I issue an UPDATE (etc.) in SQL in SQL Server Management Studio, it will give me "(1 row(s) affected)". Neither LINQPad (in SQL mode) or Query Express will do this. Could you please add this?
51
votes
anonymous
shared this idea
-
Jeff M
commented
Or, more like what you asked for, you can PRINT the ROWCOUNT:
UPDATE table SET field = 0 WHERE field = 123456
PRINT convert(varchar(30),@@ROWCOUNT) + ' records affected' -
Jeff M
commented
Found a temp solution. Use the OUTPUT clause. Link: http://programming4.us/Database/3720.aspx