对比两个表中，字段名不一样的SQL

 

需要包括有几种情况
一、A表中有的字段B表无
二、B表有的A表无
三、两个表字段名不一致的

------------------------------------------------------------------------

如果只对比字段名,可以这样

一、A表中有的字段B表无
select name from syscolumns where id=object_id('A') and name not in(select name from syscolumns where id=object_id('B'))
二、B表有的A表无
select name from syscolumns where id=object_id('B') and name not in(select name from syscolumns where id=object_id('A'))
三、两个表字段名不一致的
select name from syscolumns where id=object_id('A') and name not in(select name from syscolumns where id=object_id('B'))
union 
select name from syscolumns where id=object_id('B') and name not in(select name from syscolumns where id=object_id('A'))