IF NOT EXISTS (SELECT syscolumns.name FROM syscolumns RIGHT OUTER JOIN sysobjects ON syscolumns.id = sysobjects.id WHERE (sysobjects.name='mis_workflow_forms_list') AND (syscolumns.name='update_dateformate_flag')) alter table mis_workflow_forms_list ADD update_dateformate_flag tinyint DEFAULT 0;
在SQL Server Management Studio(SQL Server管理器)中,点击新建查询,找到数据库:clicksun,然后执行以上语句即可: