注册
登录
| 关键词： nbsp name left xtype join lengthhaving sysobjects syscolumns systypes 相同 |
写的真不错，大家可能用到 。找出表a1,a2相同的列名：select left(A.name, 20) col, left(C.name,20) type, A.length from syscolumns A left join sysobjects B on A.id = B.id left join systypes C on A.xtype = C.xtype where B.name = 'a1' or B.name = 'a2'group by A.name, C.name, A.lengthhaving count(A.name) > 1go |
|
声明：文章版权归原作者所有 部分文章转自互联网 如有侵权请联系
[邮箱地址] 删除
|
