22,300
社区成员




begin distributed tran
exec @return_value = SERVER.game.dbo.存储过程名
commit tran
go
select count(*) from SERVER.game.dbo.game_user where ....
insert into SERVER.game.dbo.game_user(user_id,user_name) values(@user_id,@user_name)
begin distributed tran
select count(*) from SERVER.game.dbo.game_user where ....
insert into SERVER.game.dbo.game_user(user_id,user_name) values(@user_id,@user_name)
commit tran
go
begin tran
if((select count(*) from SERVER.game.dbo.game_user where user_id = @user_id) = 0)
insert into game.dbo.game_user(user_id,user_name) values(@user_id,@user_name)
if(@@error <> 0)
begin
rollback tran
return -1
end
commit tran
return 1
begin tran
if((select count(*) from SERVER.game.dbo.game_user where user_id = @user_id) = 0)
insert into SERVER.game.dbo.game_user(user_id,user_name) values(@user_id,@user_name)
if(@@error <> 0)
begin
rollback tran
return -1
end
commit tran
return 1