1、添加新列
alter table Hishop_FGroup add GroupStatus bit
2、添加新列时设置默认值
ALTER TABLE Hishop_FGroup ADD GroupEffective bit DEFAULT 0
3、给现有列添加默认值
alter table Hishop_FGroup
add constraint gs default 1 for GroupStatus
爱要怎么说出口
http://blog.csdn.net/maxwell_nc/article/details/45916189