to pengdali: 结 select [from n to m] from table的帖子。
你的方法和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 )')
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 )')
...全文


