按指定排序SQL技巧

create table T_T
(id int)
insert into T_T
select 3 union all
select 8 union all
select 5 union all
select 9 union all
select 2

select * from T_T

select * from [T_T] where [id]in (2,5,9,3,8)
order by charindex(','+cast([id] as varchar)+',',','+ '2,5,9,3,8' +',')