create function row_count
(@tablename varchar(200))
returns table
as return(
with row_count(name,count)as
( select name,sum(rows) count
from sys.partitions p
left join sys.allocation_units a ON p.partition_id = a.container_id
,sysobjects c
where
p.object_id = c.id
and p.index_id in(0,1)
and p.rows is not null
and a.type = 1
and c.type = 'U'
group by name )
select * from row_count where name = (case @tablename when '*' then name else @tablename end )
)
(@tablename varchar(200))
returns table
as return(
with row_count(name,count)as
( select name,sum(rows) count
from sys.partitions p
left join sys.allocation_units a ON p.partition_id = a.container_id
,sysobjects c
where
p.object_id = c.id
and p.index_id in(0,1)
and p.rows is not null
and a.type = 1
and c.type = 'U'
group by name )
select * from row_count where name = (case @tablename when '*' then name else @tablename end )
)
扫一扫
349
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
