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