如何計算出每個表的記錄數？
現有一表A,計錄了數據據中各表的表名
我現在想得到每個表的記錄數
我想這樣寫，可是不行，請高手指點下
Select A.TableName,記錄數＝(Select count(*) from a.TableName)
From A
[解决办法]
select tablename,cou=(select count(1) from a where tablename=b.tablename)
from a b
[解决办法]
select 'select TableName= ' ' ' + TableName + ' ' ', 记录数=count(*) from ' + TableName from A
--把结果集粘贴出来运行
[解决办法]
declare @sql varchar(1000)
set @sql= 'Select A.TableName,記錄數＝(Select count(*) from ( '+select a.tablename from a) t+ ') From A '
[解决办法]
用存储过程 然后拼成字符串执行
[解决办法]
--one: 使用系统表.
SELECT object_name (i.id) TableName, rows as RowCnt
FROM sysindexes i INNER JOIN sysObjects o ON (o.id = i.id AND o.xType = 'U ')
WHERE indid < 2
ORDER BY TableName
--******************
--two: 使用未公开的过程 "sp_MSforeachtable "
CREATE TABLE #temp (TableName VARCHAR (255), RowCnt INT)
EXEC sp_MSforeachtable 'INSERT INTO #temp SELECT ' '? ' ', COUNT(*) FROM ? '
SELECT TableName, RowCnt FROM #temp ORDER BY TableName
DROP TABLE #temp
--******************
-- three: 使用游标.cursor
SET NOCOUNT ON
DECLARE @tableName VARCHAR (255), @sql VARCHAR (300)
CREATE TABLE #temp (TableName VARCHAR (255), rowCnt INT)
DECLARE myCursor CURSOR FAST_FORWARD READ_ONLY FOR
SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'base table '
OPEN myCursor
FETCH NEXT FROM myCursor INTO @tableName
WHILE @@FETCH_STATUS = 0
BEGIN
EXEC ( 'INSERT INTO #temp (TableName, rowCnt) SELECT ' ' ' + @tableName + ' ' ' as tableName, count(*) as rowCnt from ' + @tableName)
FETCH NEXT FROM myCursor INTO @tableName
END
SELECT TableName, RowCnt FROM #temp ORDER BY TableName
CLOSE myCursor
DEALLOCATE myCursor
DROP TABLE #temp
[解决办法]
SQLSERVER中统计所有表的记录数:
http://blog.csdn.net/minisunny/archive/2007/09/19/1791760.aspx
[解决办法]
exec sp_MSforeachtable 'SELECT ' '? ' ' as tablename,count(*) as count FROM ? '
[解决办法]
汗！！！！！！！！！
[解决办法]
select count(*) from 表名
[解决办法]
study
[解决办法]
mark 一下
[解决办法]
select count(*) as '表记录总数 ' from tablename
就ok了啊
[解决办法]
gdgdgdgsgdgsdgsdg
[解决办法]
select TableName,count(*) From A Group by TableName
[解决办法]
对了,要拼字符串,变量不能作为表名和字段名.
[解决办法]
function getSqlNumber($sqlQuery) {
$query=@mysql_query($sqlQuery);
$result=@mysql_num_rows($query);
@mysql_free_result($query);
return $result;
}
