--> 测试数据：[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]

------解决方案--------------------
如下图的位置修改.