CREATE PROCEDURE [dbo].[up_delete_character_title]
	@character_id	[uniqueidentifier],
	@del_title_id	[uniqueidentifier]
as 
set nocount on

begin tran

	DELETE FROM CharacterTitle WHERE [id] = @del_title_id

DECLARE @ERR int

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

COMMIT TRAN	

RETURN (@ERR)