摘要:
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 阅读全文
posted @ 2011-11-23 16:11
JetWu
阅读(3388)
评论(1)
推荐(1)
浙公网安备 33010602011771号