谢谢!create proc 名
@页的大小 int,
@第几页 int
as
exec('SELECT Top '+cast(@页的大小 as varchar)+' * FROM T WHERE SortField NOT IN (SELECT TOP '+cast(@页的大小 * @第几页 as varchar)+' SortField from T )')
@页的大小 int,
@第几页 int
as
exec('SELECT Top '+cast(@页的大小 as varchar)+' * FROM T WHERE SortField NOT IN (SELECT TOP '+cast(@页的大小 * @第几页 as varchar)+' SortField from T )')
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货