事务

1
begin transaction
2
declare @MyError
3
set @MyError = 0
4
begin transaction
5
语句1
6
set @MyError += @@error
7
语句2
8
set @MyError += @@error
9

10
if @MyError = 0
11
begin
12
    commit transaction
13
    print N'成功'
14
end
15
else
16
begin
17
    rollback transaction
18
    print N'失败'
19
end