DECLARE@tableNameNVARCHAR(MAX)DECLARE@sqlNVARCHAR(MAX)=''CREATETABLE#TempTable(TableNameSYSNAME,RowCountsBIGINT)--遍历所有用户表DECLARETableCursorCURSORFORSELECTt.NAMEFROMsys.tablestWHEREt.is_ms_shipped=0--过滤掉系统表ANDt.na

SqlServer中获取数据库中每个表的行数CREATETABLE#RowCounts(NumberOfRowsBIGINT,TableNameVARCHAR(128))EXECsp_MSForEachTable'INSERTINTO#RowCountsSELECTCOUNT_BIG(*)ASNumberOfRows,''?''asTableNameFROM?'SELECTTableName,Numbe

SqlServer中获取数据库中每个表的行数CREATETABLE#RowCounts(NumberOfRowsBIGINT,TableNameVARCHAR(128))EXECsp_MSForEachTable'INSERTINTO#RowCountsSELECTCOUNT_BIG(*)ASNumberOfRows,''?''asTableNameFROM?'SELECTTableName,Num