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

韩冰

写的真不错，大家可能用到 。 ' `3 [4 Q; l" f9 I* E) E找出表a1,a2相同的列名： select left(A.name, 20) col, left(C.name,20) type, A.length from - d, J9 a. l5 ?: ^2 g. j: L" s9 j syscolumns A left join sysobjects B 0 A; j8 s' x, _% _! q" Y! D on A.id = B.id left join systypes C on A.xtype = C.xtype - Q" [2 W! y" v8 ~1 _ ]$ G& k* c where B.name = 'a1' or B.name = 'a2' $ d: J- I% d8 w0 W* I 5 d! i/ x0 z6 fgroup by A.name, C.name, A.length having count(A.name) > 1 8 c' U, y* F2 w5 e0 ]0 C& d8 U go