-- select name from syscolumns where id = object_id('ta') and name not in (select name from syscolumns where id = object_id('tb'))
if not exists ( select 1 from syscolumns where id=object_id('ta') and name not in(select name from syscolumns where id=object_id('tb')) ) print '相同' else print '不同'
--
select name from syscolumns where id = object_id('ta') and name not in
(select name from syscolumns where id = object_id('tb'))
select 1 from syscolumns where id=object_id('ta')
and name not in(select name from syscolumns where id=object_id('tb'))
)
print '相同'
else
print '不同'