没有合适的关键词，百度、google都没找到，我自己的离线也没找到
最后还是从工作日志里搜到的：2006.9.6的事情！

http://www.cndev.org/forum/msg.aspx?pid=391689

最后发现sqk2k5+win2k3iis就有这个问题


[2416] 15:17:02.530|SQL=[
select a.*,isnull(b.fprevid,-1) fprevid,isnull(c.fnextid,-2) fnextid
from (SELECT * FROM tbInfo where fID='1' ) a
left join (select top 1 1 as fid,fid as fprevid from tbinfo where fid<1 order by fprevid desc) b
on a.fid=b.fid
left join (select top 1 1 as fid,fid as fnextid from tbinfo where fid>1 order by fnextid) c
on a.fid=c.fid
]

好像只要b、c两个子表有一个为空，asp就得不到结果了
而按理说，只要a不空就行了。。。。
美好为：【
select a.*,
isnull(b.fprevid,-1) fprevid,
isnull(c.fnextid,-2) fnextid
from (SELECT *
FROM tbInfo
where fID = '1') a
left join (select top 1 1 as fid,
fid as fprevid
from tbinfo
where fid < 1
order by fprevid desc) b
on a.fid = b.fid
left join (select top 1 1 as fid,
fid as fnextid
from tbinfo
where fid > 1
order by fnextid) c
on a.fid = c.fid
】


[2416] 16:04:16.445|SQL=[
select *,
isnull((select max(fid) fprevid from tbinfo where fid<1),-1) fprevid,
isnull((select min(fid) fnextid from tbinfo where fid>1),-2) fnextid
from tbInfo where fID=1 ]
就都没问题了。。。。

但是刚才的sql写法，按理说也是对的
不应该分析器可以达到，asp的ado就得不到。。。。
美好为：【
select *,
isnull((select max(fid) fprevid
from tbinfo
where fid < 1),-1) fprevid,
isnull((select min(fid) fnextid
from tbinfo
where fid > 1),-2) fnextid
from tbInfo
where fID = 1
】