不能通过alter table tb_name alter column的方式加default,需要先drop掉这个columnalter table tb_name drop column numberalter table tb_name add number uniqueidentifier Not null default (newid())
先drop column? 以前的数据不是就丢失了?
跟踪企业管理器,得到如下语句: ALTER TABLE dbo.tbl_wh_bill_detail ADD CONSTRAINT DF_tbl_wh_bill_detail_number DEFAULT newid() FOR number
跟踪企业管理器,得到如下语句: ALTER TABLE dbo.tbl_wh_bill_detail ADD CONSTRAINT DF_tbl_wh_bill_detail_number DEFAULT newid() FOR number
以前的数据不是就丢失了?
ALTER TABLE dbo.tbl_wh_bill_detail ADD CONSTRAINT
DF_tbl_wh_bill_detail_number DEFAULT newid() FOR number
ALTER TABLE dbo.tbl_wh_bill_detail ADD CONSTRAINT
DF_tbl_wh_bill_detail_number DEFAULT newid() FOR number