Using correlated subquery in SQL Server update statement gives ...

Trying to explain why it doesn't work as you expect: I would expect the subquery to be executed for each row because I'm referencing t1. It is executed ...

www.google.com.tw