借用goujie的回答,见帖子932289,932280
if Exists (select * from (select sysobjects.name as 表名 ,syscolumns.name as 列名 from sysobjects,syscolumns where sysobjects.id =syscolumns.id) report_zycxj_tj
where report_zycxj_tj.表名='report_zycxj_tj' and report_zycxj_tj.列名='发卡')
print 'Have!'
else
begin
print 'No Have!'
alter table report_zycxj_tj add 发卡 float default 0.00
end
select * from report_zycxj_tj