Skip to content

Instantly share code, notes, and snippets.

@hsuyuming

hsuyuming/update_in_same_transaction

Created August 22, 2019 16:27
Show Gist options
  • Save hsuyuming/2627fdc95b6269af36853e692dd2f252 to your computer and use it in GitHub Desktop.
Save hsuyuming/2627fdc95b6269af36853e692dd2f252 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
update_in_same_transaction
BEGIN TRANSACTION;
update dbo.TEST set COL1 = 'aaa1' where id =1;
update dbo.TEST set COL4 = 'dd1' where id =6;
update dbo.TEST set COL2 = 'bb3' where id =3;
update dbo.TEST set COL3 = 'c1',COL5='e1' where id =1;
COMMIT TRANSACTION;
select * from dbo.TEST;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment