sql事务

begn transaction

declare @errorsum int

set @errorsum=0

执行语句

set @errorsum=@errorsum+@@error

执行语句

set @errorsum=@errorsum+@@error

 

if(@errorsum<>0)

begin

     rollback transaction

end

else

begin

     commit transaction

end