if exists (select * from sysobjects A left join syscolumns B
on A.id = B.id where a.name = 'YH' and B.name = 'upLoad_Is')
print '有'
else
print '没有'
on A.id = B.id where a.name = 'YH' and B.name = 'upLoad_Is')
print '有'
else
print '没有'
if exists(select * from syscolumns where id=object_id('YH') and xtype='u' and name='upLoad_Is')
print('存在')
else
print('不存在')