27,580
社区成员
发帖
与我相关
我的任务
分享
sp_msforeachtable 'SELECT ''?'' TBNAME,SUM(SL) SL,SUM(JE) JE FROM ?',@whereand=' and NAME LIKE ''%#_aa#_bb'' ESCAPE ''#'''
--少了个#号
sp_msforeachtable 'SELECT ''?'' TBNAME,SUM(SL) SL,SUM(JE) JE FROM ?',@whereand=' and NAME LIKE ''%#_aa_bb'' ESCAPE ''#'''
use TFDB
go
declare @s varchar(max)
select @s=isnull(@s+' union all ','')+'select sum(sl) as sl,sum(je) as je from '+Name from sys.tables where name like '__[_]aa[_]bb'
exec('select sum(sl) as sl,sum(je) as je from ('+@s+') as a')