I will update 2 tables in on transactions.
My question is:
I should use something like
begin tran update table F inner join table G ... set x=1 where F is null and X is NULL Update table G inner join table F ... set y=1 Where F is not null and X is null commit
So my question is, on the first update, will the data that is null be changed for the second update to view or the data will not be changed?
If it is not changed then I must check for null on both tables but if changed then I should only check for null on the second table.
which way is it?