declare @SQLStr varchar(8000) set @SQLStr='SELECT Top '+cast(@每页大小 as varchar)+' * FROM T WHERE SortField NOT IN (SELECT TOP '+cast(@每页大小*@第几页 as varchar)+' SortField from T )' exec(@SQLStr)
select top 20 * from (select top 40 * from table order by id desc) a
select top 40 * from table minus select top 20 * from table
to大力:IDENTITY(int, 1,1)是什么意思
to: caiyunxia(monkey)/enhydraboy(乱舞的浮尘) 这样select执行速度不是很慢?
IDENTITY(int, 1,1),是构造一顺序序列。。
建列rowguiduniqueidentifier 默认值newid() 或id 类型 int 默认值 IDENTITY(int, 1,1)
set @SQLStr='SELECT Top '+cast(@每页大小 as varchar)+' * FROM T WHERE SortField NOT IN (SELECT TOP '+cast(@每页大小*@第几页 as varchar)+' SortField from T )'
exec(@SQLStr)
这样select执行速度不是很慢?
或id 类型 int 默认值 IDENTITY(int, 1,1)