快速查询总行数的方法

select rowcnt from sysindexes where id=object_id('表名')
select rowcnt from sysindexes where id=object_id('表名') and indid=1