View affected rows of UPDATE query

Hello all,

When you run a SQL update query, it will spit out “ (x) rows affected”… is there any way to see what rows of which tables/views the query is affecting or have SQL print out the names of the tables/views/rows that get updated?

Thanks,

MDH