排序

--控制字段排序
declare @asc int=0
select * from rowt order by (case when @asc=1 then id else name end ) desc

 

--控制升序或降序(如查排序的字段为数字类型)
declare @tag int=0;

select *,orderby=(CASE WHEN @tag = 1 THEN id * 1 else id * -1 END) from rowt order by orderby desc