SQLSERVER 建表设置字段默认值

create schema DM
go

CREATE TABLE DM.DIM_PP_Co_borrower(
    PP_Co_borrower_Key int identity(1,1) not null,
    Marital_Status Nvarchar(100),
    PP_as_Co_borrower Nvarchar(20),
    ID  int,
    [SRS_SYS_INSERTDATE] [datetime] NULL,
    [SRS_SYS_UPDATEDATE] [datetime] null,
    [SRS_SYS_ISCURRENTFLAG] int NULL,
    [EFFECTIVE_DATE] int NULL,
    [INEFFECTIVE_DATE] int NULL
) ON [PRIMARY]

GO

ALTER TABLE DM.DIM_PP_Co_borrower ADD  DEFAULT (getdate()) FOR [SRS_SYS_INSERTDATE]
GO
ALTER TABLE DM.DIM_PP_Co_borrower ADD  DEFAULT (getdate()) FOR [SRS_SYS_UPDATEDATE]
GO
ALTER TABLE DM.DIM_PP_Co_borrower ADD  DEFAULT (1) FOR [SRS_SYS_ISCURRENTFLAG]
GO
ALTER TABLE DM.DIM_PP_Co_borrower ADD  DEFAULT (cast(CONVERT(varchar(8), GETDATE(), 112) as int)) FOR [EFFECTIVE_DATE]
GO
ALTER TABLE DM.DIM_PP_Co_borrower ADD  DEFAULT (99991231) FOR [INEFFECTIVE_DATE]
GO

insert DM.DIM_PP_Co_borrower(Marital_Status,PP_as_Co_borrower,ID)values('F','AGG',1234)