21 lines
433 B
Transact-SQL
21 lines
433 B
Transact-SQL
CREATE PROCEDURE [dbo].[up_update_reward]
|
|
@character_id [uniqueidentifier],
|
|
@reward_type tinyint,
|
|
@reward_code int,
|
|
@reward_count int,
|
|
@reward_grade int,
|
|
@reward tinyint
|
|
|
|
AS
|
|
SET NOCOUNT ON
|
|
|
|
BEGIN
|
|
UPDATE RewardTable
|
|
SET reward_code = @reward_code,
|
|
reward_count= @reward_count,
|
|
reward_grade= @reward_grade,
|
|
reward = @reward
|
|
WHERE reward_type = @reward_type and character_id = @character_id
|
|
END
|
|
|
|
RETURN @@error
|