MS SQL - When using multiple UPDATES in a single query, will the WHERE clause use the current or updated field values?
SQL Server : when using multiple UPDATES in a single query, will the WHERE clause use the current or updated field values?