select t.name,c.name from sysobjects as t,syscolumns as c where t.name ='icrm_host' and t.id =c.id and t.name+c.name not in( select t1.name+c1.name from iCRM..sysobjects as t1,iCRM..syscolumns as c1 where t1.name ='icrm_host' and t1.id =c1.id )---------- 这个可以查出不一样的字段名,完整的怎么写,你参看一下语句,到数据库查一下把,反正这个会涉及到系统表
select t.name,c.name from sysobjects as t,syscolumns as c where t.name ='表名' and t.id =c.id and t.name+c.name not in( select t1.name+c1.name from 数据库2..sysobjects as t1,数据库2..syscolumns as c1 where t1.name ='表名' and t1.id =c1.id )
from sysobjects as t,syscolumns as c
where t.name ='icrm_host'
and t.id =c.id
and t.name+c.name not in(
select t1.name+c1.name
from iCRM..sysobjects as t1,iCRM..syscolumns as c1
where t1.name ='icrm_host'
and t1.id =c1.id
)----------
这个可以查出不一样的字段名,完整的怎么写,你参看一下语句,到数据库查一下把,反正这个会涉及到系统表
from sysobjects as t,syscolumns as c
where t.name ='表名'
and t.id =c.id
and t.name+c.name not in(
select t1.name+c1.name
from 数据库2..sysobjects as t1,数据库2..syscolumns as c1
where t1.name ='表名'
and t1.id =c1.id
)