存储过程里面的回滚操作

[New919]

想问问怎么在存储过程里面写回滚的操作
一旦存储过程实行不完全成功的时候
回滚执行成功的操作
高手帮忙

[New919]

create proc insertTest(@id int , @name varchar(20))
as
begin transaction
insert into test values(@id,@name)
insert into test values(@id,@name)
if (@@error<> 0)
rollback transaction
else
commit transaction

[Liao_0769]

if (@@error<> 0)
rollback transaction
else
commit transaction

[hainang1234]

begin transaction--启动事务
...
rollback transaction--回滚事务
...
commit transaction--提交事务

[bitliuyang]

事务回滚：
BEGIN TRANSACTION
SAVE TRANSACTION SAG(事务保存点)
INSERT INTO 表...
DELETE FROM ...
IF @@ERROR<>0
ROLLBACK TRANSACTION SAG
ELSE
COMMIT TRANSACTION