先删除默认 ALTER TABLE TAB_PRODSTOCK DROP CONSTRAINT 'DF__TAB_PRODS__F_STO__15502E78'
ALTER TABLE TAB_PRODSTOCK drop constraint DF__TAB_PRODS__F_STO__15502E78
declare @name varchar(20) select @name=b.name from syscolumns a,sysobjects b where a.id=object_id('TAB_PRODSTOCK') and b.id=a.cdefault and a.name='F_STOCKQUANT' and b.name like 'DF%'exec('alter table TAB_PRODSTOCK drop constraint '+@name) ALTER TABLE TAB_PRODSTOCK ALTER COLUMN F_STOCKQUANT numeric(19,3) alter table TAB_PRODSTOCK add constraint DF__TAB_PRODS__F_STO__15502E78 default 0 /*你的默认值*/ for F_STOCKQUANT
ALTER TABLE TAB_PRODSTOCK DROP CONSTRAINT 'DF__TAB_PRODS__F_STO__15502E78'
select @name=b.name from syscolumns a,sysobjects b where a.id=object_id('TAB_PRODSTOCK') and b.id=a.cdefault and a.name='F_STOCKQUANT' and b.name like 'DF%'exec('alter table TAB_PRODSTOCK drop constraint '+@name) ALTER TABLE TAB_PRODSTOCK ALTER COLUMN F_STOCKQUANT numeric(19,3)
alter table TAB_PRODSTOCK add constraint DF__TAB_PRODS__F_STO__15502E78 default 0 /*你的默认值*/ for F_STOCKQUANT