SQL建表字段语法DEFAULT和字段 NULL的组合定义表现

SQL建表字段语法DEFAULT 和 字段 NULL的组合定义表现

drop TABLE [dbo].[Ap_testtmp]

go
CREATE TABLE [dbo].[Ap_testtmp](
[Auto_ID] [int] IDENTITY(1,1) NOT NULL,
[ID] nvarchar(1) NOT NULL,

[iDAmount_1] [money] NULL DEFAULT (0),
[iDAmount_2] [money] not null DEFAULT (0),
[iDAmount_3] [money] NULL,

CONSTRAINT [aaaaaAesttmpPK] PRIMARY KEY CLUSTERED 
(
[Auto_ID] ASC
) ON [PRIMARY]
)

SELECT * from [Ap_testtmp]

insert into [Ap_testtmp](ID,iDAmount_1)
values('4',100)
insert into [Ap_testtmp](ID,iDAmount_2,iDAmount_3)
values('3',100,0)
insert into [Ap_testtmp](ID,iDAmount_2)
values('2',100)
insert into [Ap_testtmp](ID,iDAmount_1,iDAmount_2,iDAmount_3)
values('1',100,100,100)