35 lines
746 B
Transact-SQL
35 lines
746 B
Transact-SQL
CREATE PROCEDURE [dbo].[up_update_battleinfo]
|
|
@character_id [uniqueidentifier],
|
|
@total_win int,
|
|
@total_lose int,
|
|
@team_win int,
|
|
@team_lose int,
|
|
@leader_win int,
|
|
@leader_lose int,
|
|
@tag_win int,
|
|
@tag_lose int,
|
|
@death_win int,
|
|
@death_lose int,
|
|
@individual_win int,
|
|
@individual_lose int
|
|
|
|
as
|
|
set nocount on
|
|
|
|
update dbo.BattleInfo set
|
|
total_win = @total_win,
|
|
total_lose = @total_lose,
|
|
team_win = @team_win,
|
|
team_lose = @team_lose,
|
|
leader_win = @leader_win,
|
|
leader_lose = @leader_lose,
|
|
tag_win = @tag_win,
|
|
tag_lose = @tag_lose,
|
|
death_win = @death_win,
|
|
death_lose = @death_lose,
|
|
pvp_win = @individual_win,
|
|
pvp_lose = @individual_lose
|
|
|
|
where character_id = @character_id
|
|
|
|
return @@error
|