34,575
社区成员
发帖
与我相关
我的任务
分享
declare @sql varchar(8000)
select
@sql=isnull(@sql+'union all select * from ','select * from ')+'['+name+']'
from sysobjects
where xtype= 'U' and left(name,4)='TBNM'
set @sql='select * from ('+@sql+') t where FDNM=123456'
exec (@sql)
declare @sql varchar(8000)
select
@sql=isnull(@sql+'union all select * from ','select * from ')+'['+name+']'
from sysobjects
where xtype= 'U' and name like 'TBNM%'
set @sql='select * from ('+@sql+') t where FDNM=123456'
--print @sql
exec (@sql)