How are Update statements tested? Does it actually do the update on the database? Does it start a transaction then end it?
解决办法
To test Update statements, SQL Optimizer will run the statement and then rollback the transaction so it does not save it. The Update never takes effect.
