sqlserver统计所有表记录数
CREATE PROCEDURE [dbo].[StaticTableCount]ASBEGINCREATE TABLE #temp (TableName VARCHAR (255), RowCnt INT)EXEC sp_MSforeachtable 'INSERT INTO #temp SELECT ''?'', COUNT(*) FROM ?'SELECT TableName, RowCnt FROM #temp ORDER BY RowCnt descDROP TABLE #temp
原创
2020-06-16 20:34:07 ·
872 阅读 ·
0 评论