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

韩冰

写的真不错，大家可能用到 。 . q1 }( j+ w' |! k找出表a1,a2相同的列名： select left(A.name, 20) col, left(C.name,20) type, A.length from ; v6 e; D& R8 a" p1 z4 v + i7 K4 g& @3 k7 \7 G syscolumns A left join sysobjects B " y+ v9 V; M: l' `9 i3 _: _5 e4 R7 W on A.id = B.id left join systypes C + Y( e5 M+ y0 m on A.xtype = C.xtype ! ]2 B) a2 S4 x' ? where B.name = 'a1' or B.name = 'a2' group by A.name, C.name, A.length 4 ]/ ^" E9 ?! W4 i + C1 x" _0 r% Z: `! J4 U& v3 Ohaving count(A.name) > 1 ' h2 b) T5 D& P% h; I6 D3 \( U6 K# M / i1 N' I$ _3 b8 [2 s0 Wgo * ^2 G" I x7 _4 O; o