摘要： Sql中的按In排序语句：select * from userTableName Where userFiledName IN (110,120,119,114,122) order by CHARINDEX(RTRIM(CAST(userFiledName as NCHAR)),'110,120,119,114,122') select *,CHARINDEX(RTRIM(CAST(userFiledName as NCHAR)),'110,120,119,114,122') as SortNumber from userTableName Where use 阅读全文