Careful with SQL server Update: The Blog is sharing my experience with the update statement in SQL server. We need to careful when write a update statement in SQL server like a scenarios below.
Initial setup:
create table A ( c1 int, c2 int ) create table B ( c1 int, c2 int ) insert into A values (101,0) insert into A values (102,0) insert into A values (103,0) insert into B values (101,7) insert into B values (102,5) insert into B values (103,4)...
