server-re/decomp/schema/RustyHearts/procs/up_select_battle_rank.sql

11 lines
267 B
Transact-SQL

CREATE PROCEDURE [dbo].[up_select_battle_rank]
@rank_type [int]
as
begin
set nocount on
set transaction isolation level read uncommitted
select grade, char_name, char_class, duel_exp, total_win, total_lose
from BattleRank
where rank_type = @rank_type
end