CREATE PROCEDURE [dbo].[up_event_character_setting]

as begin

set nocount on

UPDATE [dbo].[CharacterTable]
   SET 
       [Job]        = 0
      ,[Level]      = 20
      ,[Experience] = 1131750
      ,[SP]         = 400
      ,[Total_SP]   = 400
      ,[gold]       = 1000000
      ,[Hearts]     = 500
 WHERE name like 'test5%'




end