让sql话语不排序，按照in语句的顺序返回结果

oracle写法：

?

?Select * from web_pics where id In (8234030,8234025,8234036) order By instr(',8234030,8234025,8234036,',',' || id || ',' )

?

sqlserver写法：

?

?Select?* From Product Where id in (1,1588,15782,9887,54) ?Order By charindex(','+ id +',', ',1,1588,15782,9887,54,')

1 楼 Rooock 2010-12-09  

正好.