Try something like this:
UPDATE table SET column = newvalue WHERE ...; SELECT @@ROWCOUNT
The SELECT @@ROWCOUNT will return the number of rows affected by the UPDATE. In general, you'll get better performance by calling a stored procedure and passing parameters but this will get you by.
-Mike