sql查询语句

java_303 2008-06-30 02:28:35

我想查询出数据库中的多少条记录
sql语句怎么写。
我要得到的是多少条数据数。

...全文

64 7 打赏收藏转发到动态举报

写回复

用AI写文章

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

lgxyz 2008-06-30

打赏
举报

如果是查整个数据库里的总记录
是１楼的写法

declare @sql varchar(8000)

select @sql=isnull(@sql+' union all ','')+'select count(*) as [acount] from '+quotename(name)+''

from (select name from sysobjects where xtype='U')tp

exec( 'select sum(acount) from ('+@sql+')tp')

ChinaITOldMan 2008-06-30

打赏
举报

select count(*) from tablename

sq1402 2008-06-30

打赏
举报

select count(*) from TableName

jc_liumangtu 2008-06-30

打赏
举报

SELECT count(*) from table

lgxyz 2008-06-30

打赏
举报

SELECT COUNT(*) FROM 表

SQLnewlearner 2008-06-30

打赏
举报

select count(*) from table_name

wzy_love_sly 2008-06-30

打赏
举报

declare @sql varchar(8000)

select @sql=isnull(@sql+' union all ','')+'select count(*) as [con] from ['+name+']'

from (select name from sysobjects where xtype='U')tp

exec( 'select sum(con) from ('+@sql+')tp')