declare @T_SQL varchar(8000)
set @T_SQL=''
select @T_SQL=@T_SQL + 'select count(*) as num from ' + 表名 + ' union all ' from 存表名的表
set @T_SQL=left(@T_SQL,len(@T_SQL)-len(' union all '))
set @T_SQL='select sum(num) from (' + @T_SQL + ') T'
exec (@T_SQL)
declare @T_SQL varchar(8000)
set @T_SQL=''
select @T_SQL='select count(*) as num from ' + 表名 + ' union all ' from 存表名的表
set @T_SQL=left(@T_SQL,len(@T_SQL)-len(' union all '))
set @T_SQL='select sum(num) from (' + @T_SQL + ') T'
exec (@T_SQL)