判断表中字段是否存在并添加

if not exists (select 1 from syscolumns where id = object_id('z_qx') and name = 'q90')
   ALTER TABLE z_qx ADD q90 VARCHAR(64) NULL
go