第一步:将字段为空的信息更改为默认值
第二步:更改字段为非空
第三步:设置默认值约束
update TableImageQuality set ImageScore= 0 where ImageScore is null ALTER TABLE TableImageQuality ALTER COLUMN ImageScore VARCHAR(10) not null update TableImageQuality set FilmScore= 0 where FilmScore is null ALTER TABLE TableImageQuality ALTER COLUMN FilmScore VARCHAR(10) not null update TableImageQuality set DImageScore= 0 where DImageScore is null ALTER TABLE TableImageQuality ALTER COLUMN DImageScore VARCHAR(10) not null update TableImageQuality set ReportScore= 0 where ReportScore is null ALTER TABLE TableImageQuality ALTER COLUMN ReportScore VARCHAR(10) not null update TableImageQuality set AuditScore= 0 where AuditScore is null ALTER TABLE TableImageQuality ALTER COLUMN AuditScore VARCHAR(10) not null update TableImageQuality set ApplicationScore= 0 where ApplicationScore is null ALTER TABLE TableImageQuality ALTER COLUMN ApplicationScore VARCHAR(10) not null alter table TableImageQuality add default (0) for ImageScore with values alter table TableImageQuality add default (0) for FilmScore with values alter table TableImageQuality add default (0) for DImageScore with values alter table TableImageQuality add default (0) for ReportScore with values alter table TableImageQuality add default (0) for AuditScore with values alter table TableImageQuality add default (0) for ApplicationScore with values
标签:非空,null,VARCHAR,--,set,TableImageQuality,table,默认值,ALTER From: https://www.cnblogs.com/YYkun/p/17994588