1.检索项为INT型
SELECT * FROM IEMModels WHERE ModelID IN (7,9,5) ORDER BY CHARINDEX(','+rtrim(cast(ModelID as varchar(10)))+',',',7,9,5,')
2.检索项为VARCHAR型
SELECT * FROM IEMModels WHERE ModelDes IN ('b','a','c') ORDER BY CHARINDEX(ModelDes,'b,a,c');
1.检索项为INT型
SELECT * FROM IEMModels WHERE ModelID IN (7,9,5) ORDER BY CHARINDEX(','+rtrim(cast(ModelID as varchar(10)))+',',',7,9,5,')
2.检索项为VARCHAR型
SELECT * FROM IEMModels WHERE ModelDes IN ('b','a','c') ORDER BY CHARINDEX(ModelDes,'b,a,c');
转载于:https://www.cnblogs.com/mr-yan/p/6148189.html