sql实现自定义排序

select * from table1

order by CHARINDEX(','+CONVERT(varchar(10),ID)+',',',123,789,456,') 

 

select Product.*, CHARINDEX(','+CONVERT(varchar(10),ID)+',',',123,789,456,') As IdIndex    

from table1

order by IdIndex