CREATE PROCEDURE [dbo].[up_character_rob]
	@bcust_id nvarchar(50),
	@auth_id [uniqueidentifier],
	@name nvarchar(16)

as begin

set nocount on

	declare @char_id uniqueidentifier
	--declare @WindyCode nvarchar(50)

	select @char_id   = character_id from CharacterTable with (READUNCOMMITTED) where [name] = @name
	--select @WindyCode = WindyCode from [RustyHeartsLinkAuth].[RustyHearts_Auth].[dbo].[AuthTable] with (READUNCOMMITTED) where AuthID = @auth_id

	-- 사용할수 있는 이름인지 체크.
	UPDATE [dbo].[CharacterTable]
      SET 
	   [bcust_id] = @bcust_id --@WindyCode
	  ,[AuthID] = @auth_id
	  WHERE character_id = @char_id
end