Showing posts with label WPF. Show all posts
Showing posts with label WPF. Show all posts
Friday, 29 April 2011
Friday, 15 April 2011
Example of rollback transactions in sql
begin transaction
insert into table1 (...,...) values (...,...)
if @@error <> 0
rollback trans
else
insert into table2 (...,...) values (...,...)
if @@error <> 0
rollback trans
else
insert into table3 (...,...) values (...,...)
insert into table1 (...,...) values (...,...)
if @@error <> 0
rollback trans
else
insert into table2 (...,...) values (...,...)
if @@error <> 0
rollback trans
else
insert into table3 (...,...) values (...,...)
Subscribe to:
Posts (Atom)