java得到sql表的行数,在SqlServer中 统计用户表中数据的行数 .

declare cur cursor for

select name from sysobjects

where xtype='U'    --用户表

open cur

fetch next from cur into @tableName

while @@fetch_status=0

begin

set @sql = N'select @count=count(1) from '+@tableName

exec sp_executesql @sql,N'@count int output',@count output

--    if(@count>0)

--    begin

print '表名称：'+@tableName+' 行数：'+cast(@count as varchar)

--    end

fetch next from cur into @tableName

end

close cur

deallocate cur

posted on 2012-08-10 16:16 奋斗成就男人 阅读(740) 评论(0)  编辑  收藏 所属分类: SQL