CREATE PROCEDURE [dbo].[up_update_character_guild_point] @character_id [uniqueidentifier], @guildpoint int as begin set nocount on update CharacterTable set GuildPoint = @guildpoint where character_id = @character_id end