select rows from sysindexes where id=object_id('表名') and indid<=1 好处:快速高效,不用查询表,造成锁定 转载于:https://www.cnblogs.com/xyz0835/p/3353367.html