CREATE PROCEDURE [dbo].[up_update_guild_member_permission]
	@guild_id   	[uniqueidentifier],
	@character_id   [uniqueidentifier],
	@permission     int
as 
set nocount on

	update dbo.GuildMemberTable set grade = @permission where guild_id = @guild_id and character_id = @character_id


return @@error