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

韩冰

写的真不错，大家可能用到 。 : v% f3 Y# n5 W+ J找出表a1,a2相同的列名： " X, x+ [) E& t select left(A.name, 20) col, left(C.name,20) type, A.length from syscolumns A left join sysobjects B 4 w: b$ O- H$ ^3 F5 b6 z- ^5 k& u ; e; Z: W$ w3 a: `: k5 j on A.id = B.id left join systypes C / @7 w9 \0 \, k+ m) \) r on A.xtype = C.xtype where B.name = 'a1' or B.name = 'a2' : [5 Y% l" }% ]! _. s4 ^group by A.name, C.name, A.length having count(A.name) > 1 - N* t/ \, t) t, c* J7 Q. j $ H( V. |, F2 ]6 I8 Sgo