if exists (select * from syscolumns where id=object_id(‘表名‘) and name=‘字段名‘) print ‘有‘ else print ‘无‘
判断数据库表中是否存在某个字段
原文：http://www.cnblogs.com/huangshuqiang/p/5865504.html
