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

韩冰

写的真不错，大家可能用到 。 9 S$ U8 @) W) d& f3 L1 u- {( h6 O找出表a1,a2相同的列名： 2 ]% q/ H3 U8 W/ i$ jselect left(A.name, 20) col, left(C.name,20) type, A.length from & d9 D, W! G' W7 `4 U I9 r1 G syscolumns A left join sysobjects B . ^6 X! D: b+ t2 {5 U on A.id = B.id left join systypes C + F7 E1 i4 z( Z" |/ P on A.xtype = C.xtype where B.name = 'a1' or B.name = 'a2' 1 o1 ?: {9 D( _6 B, g4 y5 B& A group by A.name, C.name, A.length ) H5 S4 n* w! e+ L/ v & R( r# A) `7 _0 {2 thaving count(A.name) > 1 E+ G% ~9 \; o- a& ago % F4 f! d1 e o. |0 ?' |' D