select *,表數據量=b.con from systemore as a,(select count(*) con from systemore )b
要是 sys_name 里面的表的记录变化了 你打算显示什么
select a.*,表數據量=b.con from systemore as a,(select count(*) con,sys_Name from systemore group by sys_Name)b where a.sys_Name=b.sys_Name這樣?
select a.*,b.num from systemore as a join (select count(*) as num,sys_Name from systemore group by sys_Name)b on a.sys_Name=b.sys_Name
Select a.*, b.counts From Systemore A, (Select 'sys_Name' As sys_Name, Count(*) Counts From Sys_Name Group By sys_Name) B Where A.sys_Name = B.Sys_Name
你不都已经写出来了么: select *,(select count(*) from systemore where sys_name=a.sys_name)as 表数据量 from systemore a
大家的回答好像都不正确。可能还没明白我的意思。sys_name这个字段存储的是表名,存储在表systemore中。 我现在要查询我有那些表,并且表中有多少条数据。但是我并不知道表名 所以。select * from systemore 这里就已经可以查出所有的表来了。 然后 select *,'这里其实就是当前sys_name字段里的值,以它作为表名,来count(*)一次,通俗点就应该是当前的(select count(*) from systemore.sys_name)' from systemore
這樣?sys_name為表名 select a.*,表數據量=b.rows from systemore as a, (SELECT OBJECT_NAME(ID) AS sys_Name,rows FROM sysindexes WHERE indid IN(0,1))b where a.sys_Name=b.sys_Name
能解释下这句吗?(SELECT OBJECT_NAME(ID) AS sys_Name,rows FROM sysindexes WHERE indid IN(0,1))b 结果是完全正确的了 。
from systemore as a,(select count(*) con from systemore )b
select a.*,表數據量=b.con
from systemore as a,(select count(*) con,sys_Name from systemore group by sys_Name)b
where a.sys_Name=b.sys_Name這樣?
a.*,b.num
from
systemore as a join (select count(*) as num,sys_Name from systemore group by sys_Name)b
on
a.sys_Name=b.sys_Name
From Systemore A, (Select 'sys_Name' As sys_Name, Count(*) Counts From Sys_Name Group By sys_Name) B
Where A.sys_Name = B.Sys_Name
select *,(select count(*) from systemore where sys_name=a.sys_name)as 表数据量
from systemore a
我现在要查询我有那些表,并且表中有多少条数据。但是我并不知道表名
所以。select * from systemore 这里就已经可以查出所有的表来了。
然后
select *,'这里其实就是当前sys_name字段里的值,以它作为表名,来count(*)一次,通俗点就应该是当前的(select count(*) from systemore.sys_name)' from systemore
select a.*,表數據量=b.rows from systemore as a,
(SELECT OBJECT_NAME(ID) AS sys_Name,rows FROM sysindexes WHERE indid IN(0,1))b where a.sys_Name=b.sys_Name