CREATE PROCEDURE [dbo].[up_equip_character_title]
	@title_id	  [uniqueidentifier],
	@character_id [uniqueidentifier]
AS 
SET NOCOUNT ON

BEGIN TRAN

	DELETE FROM Equip_CharacterTitle WHERE [character_id] = @character_id
	
	INSERT Equip_CharacterTitle
		(
		[ID],
		[character_id],
		[title_code],
		[remain_time],
		[expire_time]
		)
	SELECT
		[ID],
		[character_id],
		[title_code],
		[remain_time],
		[expire_time]
		FROM CharacterTitle with (READUNCOMMITTED) WHERE [ID] = @title_id

DECLARE @ERR INT
SET @ERR = @@ERROR
IF @ERR <> 0
BEGIN
	--RAISERROR('처리오류', 16, 10)
	IF @@TRANCOUNT <> 0
		ROLLBACK TRAN
	RETURN (@ERR)
END
COMMIT TRAN	

RETURN @ERR