select rowcnt from sysindexes where id=object_id('表名') 转载于:https://www.cnblogs.com/xsmhero/archive/2010/11/26/1888561.html