SqlServer查询数据中按In排序语句
select *,CHARINDEX(RTRIM(CAST(ID as NCHAR)),'这里放置要查询的ID字符串以","隔开') as SortNumber from 表 Where ID IN ('ID')order by SortNumber
select *,CHARINDEX(RTRIM(CAST(ID as NCHAR)),'这里放置要查询的ID字符串以","隔开') as SortNumber from 表 Where ID IN ('ID')order by SortNumber