没脾气2x ·
·
阅读: 1225
上面的SQL写错了：
[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]
| -ICP -IDC -ISP |