CREATE PROCEDURE [dbo].[up_update_event_fortune] @character_id [uniqueidentifier], @fortune tinyint as begin set nocount on update CharacterTable set event_fortune = @fortune where character_id = @character_id end