declare @i int
set @i=0
select @i=@i+count(*) from 表1
select @i=@i+count(*) from 表2
select @i=@i+count(*) from 表3
...
select @i=@i+count(*) from 表50select @i
set @i=0
select @i=@i+count(*) from 表1
select @i=@i+count(*) from 表2
select @i=@i+count(*) from 表3
...
select @i=@i+count(*) from 表50select @i
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)
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)