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

韩冰

写的真不错，大家可能用到 。 找出表a1,a2相同的列名： * [3 i) a" y& V- ^, t9 P select left(A.name, 20) col, left(C.name,20) type, A.length from ; _9 n$ g P3 f" [1 ~5 G5 I6 D6 _ syscolumns A left join sysobjects B on A.id = B.id left join systypes C 4 e8 \( V' @* H1 ^# O2 \. z1 w on A.xtype = C.xtype where B.name = 'a1' or B.name = 'a2' ' P7 \' m4 e# O. c: G) q ) P6 o |1 Q- lgroup by A.name, C.name, A.length having count(A.name) > 1 4 R2 }8 G$ v1 a* h% D go $ b" P( y$ K- i- I+ r