21 lines
338 B
Transact-SQL
21 lines
338 B
Transact-SQL
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
|