代码
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
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