SQL Server 修改表添加列，可以为null, 指定默认值的SQL 语句



if not exists (select   * 
                from    syscolumns 
                where   id = object_id('dbo.tblMasterJobMonthsUnforecastError') 
                and     [name] = 'CC06')
begin
    alter table tblMasterJobMonthsUnforecastError
    add CC06 tDollar null default(0) with values
end
go