动态Order by时间:2023-03-09 14:54:23 declare @order varchar(50),@type varchar(10) set @order='' set @type='' select * from T_Table order by case when len(@order)>0 then ID end desc, case when LEN(@type)>0 then CreateTime end desc