按[重复]的顺序使用变量asc和desc

没有

Dynamic SQL

ORDER BY  case when @var1 = 'priority asc' THEN priority END ASC ,  case when @var1 = 'priority desc' then priority end DESC,  case when @var2 = 'report_date asc' then report_date end ASC,  case when @var2 = 'report_date desc' then report_date end DESC