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