Settings and activity
2 results found
-
51 votes
An error occurred while saving the comment An error occurred while saving the comment Jeff M commentedFound a temp solution. Use the OUTPUT clause. Link: http://programming4.us/Database/3720.aspx
Jeff M supported this idea · -
1,276 votesJeff M supported this idea ·
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'