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

韩冰

写的真不错，大家可能用到 。 找出表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 1 v9 d' r$ q; }% c& q9 _, D $ b7 ]* [6 w ]2 y$ W4 ~ on A.xtype = C.xtype ( a5 X2 d/ g! Q' K5 y N where B.name = 'a1' or B.name = 'a2' ( d1 _ D+ i \8 f group by A.name, C.name, A.length having count(A.name) > 1 0 L/ x4 x) O. v l 5 Q& h$ ?; y% v! I) o* P# igo . R- T" z' M. [+ U4 {1 A