14 Sep
1999
14 Sep
'99
4:35 p.m.
When a SQLMethod is called that modifies data through an UPDATE or INSERT statement, is there any way of finding out how many rows were affected by the change?
Some databases may expose this information in a special object. If it's a selectable object (not a stored procedure), it's easy to get the information. But by default, most databases don't return any information about how many rows were affected by a statement. And those that do probably don't do it in a uniform way.