27,579
社区成员
发帖
与我相关
我的任务
分享
SELECT *
FROM ( SELECT TOP (1000*10)*,
ROW_NUMBER() OVER ( ORDER BY 栏位列 DESC ) AS RN--倒序
FROM A
) AS t
WHERE RN BETWEEN ( 页数 - 1 ) * 10 + 1 AND 页数 * 10;
DECLARE @SUMCOUNT INT --总记录
SELECT @SUMCOUNT=rows FROM sys.sysindexes where indid in(0,1) and id = OBJECT_ID(N'student')
SET @SUMCOUNT = (CASE WHEN @SUMCOUNT >100000 THEN 100000 ELSE @SUMCOUNT END)
SELECT rows FROM sysindexes WHERE indid IN(0,1) AND id=OBJECT_ID('student')
或用
SELECT rows FROM sys.partitions WHERE object_id=OBJECT_ID('student') AND index_id IN (0,1)
select b.rowcnt as sumcount
from sys.tables a
inner join sys.sysindexes b on a.object_id=b.id
where a.name='表名' and b.indid<=1