|
數(shù)據(jù)庫(kù)中的事務(wù)
存儲(chǔ)過(guò)程里的
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
|
|
|
