[转载]如何取得两个表相同的列名

信息来源：黑基

　写的真不错，大家可能用到 。
找出表a1,a2相同的列名：

select left(A.name, 20) col, left(C.name,20) type, A.length from

syscolumns A left join sysobjects B

on A.id = B.id left join systypes C

on A.xtype = C.xtype

where B.name = 'a1' or B.name = 'a2'

group by A.name, C.name, A.length

having count(A.name) > 1

go