Транзакции и откат при ошибках |
Previous Top Next |
Code: |
Begin Tran
--©Drkb v.3(2007): www.drkb.ru
Declare @ErrorCode
Update MyTable Set MyField1=MyField2 Where MyField3=1
Set @ErrorCode=@@Error
If @ErrorCode <> 0 Rollback Else Commit |
©Drkb::02814
Автор: Vit (www.delphist.com, www.drkb.ru, www.unihighlighter.com, www.nevzorov.org)