|
数据库中的事务
存储过程里的
create proc registeruser
(
@usrName varchar(30),@userPasswd varchar(30),@age int,@phonenum
)
as
begin tran
insert into user(username,userpasswd) values (@usernmae,@usepasswd)
begin
if @@error <>0
rollback tran
return -1
end
insert into userdoc(username,age,sex)
values(@username,@age,@sex)
if @@error <>0
begin
rollback tran
return -1
end
commit tran
return 0
end
|
|
|
