计算数据库中所有包含ID字段且ID字段值为1的行数

DECLARE @sql VARCHAR(8000) SET @sql = '' SELECT @sql = @sql + ' UNION ALL SELECT COUNT(id) FROM ' + t1.NAME + ' WHERE ID=''1''' FROM sysobjects t1 JOIN syscolumns t2 ON t1.id = t2.id JOIN systypes t3 ON t2.xtype=t3.xtype --关联类型表意义在于固定ID为特定类型 WHERE t1.xtype = 'U' AND t2.NAME = 'ID' AND t3.NAME='int' EXEC ( 'SELECT SUM(c) FROM (SELECT 0 AS c' + @sql + ') t' )