CREATE PROCEDURE [dbo].[up_update_reward]
@character_id	[uniqueidentifier],
@reward_type	tinyint,
@reward_code	int,
@reward_count	int,
@reward_grade	int,
@reward			tinyint

AS
SET NOCOUNT ON 

	BEGIN
		UPDATE RewardTable
			SET reward_code	= @reward_code,
				reward_count= @reward_count,
				reward_grade= @reward_grade,
				reward		= @reward
		WHERE reward_type = @reward_type and character_id = @character_id
	END

RETURN @@error