怎么用事务,怎么回滚

[aierong]

create proc proc_my
as
create table a(
i tinyint,
ii smallint,
iii int
)
insert into a values(1,11,111)
insert into a values(2,11,111)
insert into a values(3,11,111)
insert into a values(4,18,111)
insert into a values(7,81,111)

怎么判断过程里面的操作全部成功,要是不成功,怎么样回滚,是不是要用事务
请大家帮忙我改这个过程

[aierong]

顶

[pengdali]

begin tran
insert into a values(1,11,111)
insert into a values(2,11,111)
insert into a values(3,11,111)
insert into a values(4,18,111)
insert into a values(7,81,111)
commit tran

[pengdali]

begin tran
insert into a values(1,11,111)
insert into a values(2,11,111)
insert into a values(3,11,111)
insert into a values(4,18,111)
insert into a values(7,81,111)
commit tran

[txlicenhe]

begin tran
insert into a values(1,11,111)
if @@error <> 0 then goto Err
insert into a values(2,11,111)
if @@error <> 0 then goto Err
insert into a values(3,11,111)
if @@error <> 0 then goto Err
insert into a values(4,18,111)
if @@error <> 0 then goto Err
insert into a values(7,81,111)
if @@error <> 0 then goto Err
commit
return
Err:
rollback

[yelook]

begin transaction a
SET NOCOUNT ON
SET XACT_ABORT ON
create table a(
i tinyint,
ii smallint,
iii int
)
insert into a values(1,11,111)
insert into a values(2,11,111)
insert into a values(3,11,111)
insert into a values(4,18,111)
insert into a values(7,81,111)
commit transaction

[aierong]

ding

[sysweb]

conntemp.BeginTrans
中间放程序
conntemp.CommitTrans

[aierong]

create proc proc_my
as
begin transaction
create table a(
i tinyint,
ii smallint,
iii int
)
if @@error<>0
rollback
insert into a values(1,11,111)
if @@error<>0
rollback
insert into a values(2,11,111)
if @@error<>0
rollback
insert into a values(3,11,111)
if @@error<>0
rollback
insert into a values(4,18,111)
if @@error<>0
rollback
insert into a values(7,81,111)
if @@error<>0
rollback
commit transaction




这样对吗