SELECT DISTINCT(TABLE_NAME) FROM INFORMATION_SCHEMA.Columns where COLUMN_NAME = 'test'
select b.name as 表名,a.name as 字段名 from syscolumns a inner join sysobjects b on a.id=b.id where b.xtype='U' and a.name like '%test%' select 'select * from '+b.name+ ' where '+a.name+' like ''%XXXX%''' from syscolumns a inner join sysobjects b on a.id=b.id where b.xtype='U' and a.name='date1'
SELECT DISTINCT(TABLE_NAME) FROM INFORMATION_SCHEMA.Columns where COLUMN_NAME = 'test'
from syscolumns a
inner join sysobjects b on a.id=b.id
where b.xtype='U' and a.name like '%test%'
select 'select * from '+b.name+ ' where '+a.name+' like ''%XXXX%'''
from syscolumns a
inner join sysobjects b on a.id=b.id
where b.xtype='U' and a.name='date1'