sql server 事务示例

sql

--如果出错,全回滚整个事务
SET XACT_ABORT off
begin tran
INSERT INTO [dbo].[SsoLog]           (Sl_Login_Time)     VALUES           (GETDATE())
INSERT INTO [dbo].[SsoLog]           (Sl_Login_Time)     VALUES           (222)
INSERT INTO [dbo].[SsoLog]           (Sl_Login_Time)     VALUES           ('key04')
commit tran



--如果出错,全回滚整个事务
begin tran
INSERT INTO [dbo].[SsoLog]           (Sl_Login_Time)     VALUES           (GETDATE())
INSERT INTO [dbo].[SsoLog]           (Sl_Login_Time)     VALUES           (222)
INSERT INTO [dbo].[SsoLog]           (Sl_Login_Time)     VALUES           ('key04')
commit tran
roolback 



--如果出错,全回滚整个事务
begin try
begin tran
INSERT INTO [dbo].[SsoLog]           (Sl_Login_Time)     VALUES           (GETDATE())
INSERT INTO [dbo].[SsoLog]           (Sl_Login_Time)     VALUES           (GETDATE())
INSERT INTO [dbo].[SsoLog]           (Sl_Login_Time)     VALUES           (GETDATE())

INSERT INTO [dbo].[SsoLog]           (Sl_Login_Time)     VALUES           ('key04')
commit tran
end try
begin catch
rollback
end catch