USE ExpressDBCREATE TABLE #tablespaceinfo    (      nameinfo VARCHAR(50) ,      rowsinfo BIGINT ,      reserved VARCHAR(20) ,      datainfo VARCHAR(20) ,      index_size VARCHAR(20) ,      unused VARCHAR(20)    )   --创建游标DECLARE Info_cursor CURSORFOR    SELECT  ‘[‘ + [name] + ‘]‘    FROM    sys.tables    WHERE   type = ‘U‘;   OPEN Info_cursor  DECLARE @tablename VARCHAR(255);  FETCH NEXT FROM Info_cursor INTO @tablename   WHILE @@FETCH_STATUS = 0    BEGIN         INSERT  INTO #tablespaceinfo                EXEC sp_spaceused @tablename          FETCH NEXT FROM Info_cursor      INTO @tablename      END  CLOSE Info_cursor  DEALLOCATE Info_cursor   --创建临时表CREATE TABLE [#tmptb]    (      TableName VARCHAR(50) ,      DataInfo BIGINT , -- 以数据页大小为单位计算，即使表只有一条记录，也会占用一个数据页（8KB）      RowsInfo BIGINT ,      SpacePerRow  AS ( CASE RowsInfo                         WHEN 0 THEN 0                         --ELSE DataInfo / RowsInfo -- 数据页大小的信息除以记录数。                         ELSE CAST(DataInfo AS decimal(8,2))/CAST(RowsInfo AS decimal(8,2))                       END ) PERSISTED    )--插入数据到临时表INSERT  INTO [#tmptb]        ( [TableName] ,          [DataInfo] ,          [RowsInfo]        )        SELECT  [nameinfo] ,                CAST(REPLACE([datainfo], ‘KB‘, ‘‘) AS BIGINT) AS ‘datainfo‘ ,                [rowsinfo]        FROM    #tablespaceinfo        ORDER BY CAST(REPLACE(reserved, ‘KB‘, ‘‘) AS INT) DESC  --汇总记录SELECT  [tbspinfo].* ,        [tmptb].[SpacePerRow] AS ‘每行记录大概占用空间（KB）‘FROM    [#tablespaceinfo] AS tbspinfo ,        [#tmptb] AS tmptbWHERE   [tbspinfo].[nameinfo] = [tmptb].[TableName]ORDER BY CAST(REPLACE([tbspinfo].[reserved], ‘KB‘, ‘‘) AS INT) DESC  DROP TABLE [#tablespaceinfo]DROP TABLE [#tmptb]