SQL Server表的数据量大小查询
CREATE TABLE #Temp (NAME nvarchar(100),ROWS char(20),reserved varchar(18) ,Data varchar(18) ,index_size varchar(18) ,Unused varchar(18) ) GO INSERT #Temp EXEC SP_MSFOREACHTABLE 'EXEC sp_spaceused "?"' SELECT * FROM #Temp ORDER BY CONVERT(INT,REPLACE(DATA,'KB','')) DESC DROP TABLE #Temp