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
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
转载于:https://www.cnblogs.com/godxiangyu/p/3678436.html