to pengdali: 结 select [from n to m] from table的帖子。
whoo 2003-04-02 02:48:03 你的方法和w_rose的一样,都可以。
original msg:
---------------------------------------------------------
exec('SELECT Top '+cast(@PageSize as varchar)+' * FROM T WHERE SortField NOT IN (SELECT TOP '+cast(@PageSize* @Pagei as varchar)+' SortField from T )')