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

韩冰

写的真不错，大家可能用到 。 找出表a1,a2相同的列名： 8 I4 M z1 B# o" ~- n/ b8 X # m+ ?+ G2 Y+ [" r2 ~. ~: ]/ Qselect left(A.name, 20) col, left(C.name,20) type, A.length from * s6 U; ^+ u: |2 e% \2 p syscolumns A left join sysobjects B 3 V9 A; S6 h- n% [* Y+ \3 g& [ on A.id = B.id left join systypes C , H2 V+ q4 F, V2 g$ S* B. B" L/ Z& C on A.xtype = C.xtype 8 W6 n9 z6 S5 F8 I: E& ? where B.name = 'a1' or B.name = 'a2' - E/ L. \6 d% I4 P" b# X1 Y- V# rgroup by A.name, C.name, A.length . R' ?8 g4 p$ F4 Y# [9 y ; i. c* e* d3 _' ^0 O- L* dhaving count(A.name) > 1 ! n3 y0 b# H2 T! {: K% X go ! e& \" `' s9 m; M4 k