如何取得两个表相同的列名

韩冰

写的真不错，大家可能用到 。 找出表a1,a2相同的列名： % Y9 S9 R3 x5 _ select left(A.name, 20) col, left(C.name,20) type, A.length from ) e5 |/ Q0 u7 F* s- Z syscolumns A left join sysobjects B + L. W; |' b3 J% s) i+ y: u" s on A.id = B.id left join systypes C on A.xtype = C.xtype ( |! A: G# P& {* E& ~4 J! G where B.name = 'a1' or B.name = 'a2' / f. A K) _+ ~1 Q5 r- M; m) | group by A.name, C.name, A.length having count(A.name) > 1 go