22 lines
519 B
Transact-SQL
22 lines
519 B
Transact-SQL
CREATE PROCEDURE [dbo].[up_update_uni_account_info]
|
|
@auth_id [uniqueidentifier],
|
|
@AccountStorage_Count int,
|
|
@AccountStorage_Gold int,
|
|
@Use_CharacterSlot int
|
|
as
|
|
set nocount on
|
|
|
|
declare @get_AuthID [uniqueidentifier]
|
|
declare @bcust_id nvarchar(50)
|
|
|
|
set @get_AuthID = NULL
|
|
|
|
begin
|
|
update dbo.UniAccountInfo set
|
|
AccountStorage_Count = @AccountStorage_Count,
|
|
AccountStorage_Gold = @AccountStorage_Gold,
|
|
Use_CharacterSlot = @Use_CharacterSlot
|
|
where AuthID = @auth_id;
|
|
end
|
|
|
|
return @@error
|