SQL Server中多個表格求出相同列和不同列（答案來自CSDN上SQL專家的回答）

從不同表格中求出所有列名相同的列（不考慮類型和精度等）,注意最後一列的數字3，是查詢的表格數目
select a.name ,count(1) as tt from syscolumns a,sysobjects b
where a.id=b.id and b.xtype='u' and b.name in ('table_1','table_2','table_3')
group by a.name
having count(1)=3;

從不同表格中求出相同列後，每個表格去除掉這些相同列後返回的結果

create view Test
as
select a.name ,count(1) as tt from syscolumns a,sysobjects b
where a.id=b.id and b.xtype='u' and b.name in ('table_1','table_2','table_3')
group by a.name
having count(1)=3;
go
select  a.name as 列名
from syscolumns a,sysobjects b
where b.xtype='u' and a.id=b.id  and b.name in ('table_1') and a.name not in (select name from Test)
group by b.name,a.name having count(1)=1

drop view Test

原帖地址：如何查詢出N張表中的相同列和每個表各自的不同列（N不定且表結構不能預知）