--> 测试数据:[company] IF OBJECT_ID('[company]') IS NOT NULL DROP TABLE [company] GO CREATE TABLE [company]([id] INT,[vip] CHAR(1))INSERT [company]([id]) VALUES(1) SELECT * FROM [company]ALTER TABLE [company] ADD CONSTRAINT def_company_vip DEFAULT '0' FOR [vip] ;INSERT [company]([id]) VALUES(2)SELECT * FROM [company]
字段名字 字段类型 约束(默认为0:default 0)
.....
)
IF OBJECT_ID('[company]') IS NOT NULL DROP TABLE [company]
GO
CREATE TABLE [company]([id] INT,[vip] CHAR(1))INSERT [company]([id]) VALUES(1)
SELECT * FROM [company]ALTER TABLE [company]
ADD CONSTRAINT def_company_vip DEFAULT '0' FOR [vip] ;INSERT [company]([id]) VALUES(2)SELECT * FROM [company]
这样还是不行啊,我插入一条数据,还是MULL