[阅读: 1000] 2007-04-11 02:06:15
[CODE=SQL]
SELECT TOP 10 @MaxBlockID = MAX(BlockID), @MinBlockID = MIN(BlockID)
SELECT BlockID FROM forum_msgs
WHERE board_name = 'java'
AND BlockLayerID = 0
AND BlockID < @PagedBlockID
ORDER BY BlockID DESC
SELECT * FROM forum_msgs
WHERE board_name = 'java'
AND @MinBlockID <= BlockID AND BlockID <= @MaxBlockID
ORDER BY BlockID DESC, BlockOrderID
[/CODE]
Notemper2x 3.1 (￣ε(￣#)
没脾气2x 之 个人综合篇:
http://notemper2x.cndev.org/
我的 panoramio 相册:
http://panoramio.com/user/zhaixudong
我的 flickr相册:
http://www.flickr.com/photos/notemper2x/
QQ号20250出售，售价400,000元整（5位、皇冠80级、VIP7）
| -ICP -IDC -ISP |