alter table STATIONSQUADSUM add MPAYINCASH int --添加一个可以为空的新列
go
update STATIONSQUADSUM set MPAYINCASH=0 --设置新列的值为0
go
ALTER TABLE STATIONSQUADSUM ALTER COLUMN
MPAYINCASH int not null ; --设置新列为非空
2024-03-02 23:03:22
alter table STATIONSQUADSUM add MPAYINCASH int --添加一个可以为空的新列
go
update STATIONSQUADSUM set MPAYINCASH=0 --设置新列的值为0
go
ALTER TABLE STATIONSQUADSUM ALTER COLUMN
MPAYINCASH int not null ; --设置新列为非空