传统做法可能是select count(1)
但是往往会比较慢。推荐如下做法:
SELECT ISNULL(MAX(rowcnt), 0) CurrentRowCount
FROM sys.sysindexes
WHERE id = OBJECT_ID('TableName')
查看代码
2022-12-06 21:05:18
传统做法可能是select count(1)
但是往往会比较慢。推荐如下做法:
SELECT ISNULL(MAX(rowcnt), 0) CurrentRowCount
FROM sys.sysindexes
WHERE id = OBJECT_ID('TableName')
查看代码