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

韩冰

写的真不错，大家可能用到 。 - m% f- Y2 i/ ^6 k7 E7 n- a找出表a1,a2相同的列名： 0 ?2 f+ w& i) R. p. l' o & U/ B% y7 W0 B6 Jselect left(A.name, 20) col, left(C.name,20) type, A.length from syscolumns A left join sysobjects B / l" ~5 v2 d2 b2 j on A.id = B.id left join systypes C on A.xtype = C.xtype : i) M3 r3 C- u M4 k where B.name = 'a1' or B.name = 'a2' : C1 [& O4 _$ C S+ N% g5 ]8 a6 _% ^. ~4 E8 ^1 V0 ^group by A.name, C.name, A.length having count(A.name) > 1 go ( i3 f& X) {4 W! ?6 ` 8 T, Z& e7 u; Q8 z K/ S6 L