begin tran update mrecords set dcc_Code = '1212121' update empsales set ename = 'Sarab' --commit begin tran update empsales set ename = 'Amit' update mrecords set dcc_Code = '23232' --commit