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

韩冰

写的真不错，大家可能用到 。 找出表a1,a2相同的列名： select left(A.name, 20) col, left(C.name,20) type, A.length from 9 {# E- l; g& M! D) G syscolumns A left join sysobjects B : W: b" D: X* W6 u; Z & M } X8 m" ~0 C9 S. U on A.id = B.id left join systypes C . {* I; s1 O/ y) z: s( l0 m) s/ g 1 e1 Z5 D: w/ F i* r4 m$ h on A.xtype = C.xtype # `& c3 _' P4 W( ^# ?4 h & t( }. o: a2 E. S2 t2 P1 n2 M where B.name = 'a1' or B.name = 'a2' group by A.name, C.name, A.length 7 u& ^+ {; x, O having count(A.name) > 1 - k) ~/ _0 m$ ~% ~ z4 H ; V, f6 q/ H4 Vgo