--修改数据库,新增列并默认值为1
Alter Table shougeinfo Add CANTON_ID int not null default 1
---批量更新数据,就是把默认值改为CANTON_ID
update shougeinfo
set shougeinfo.canton_id=B.[ID] from CANTON B
where substring(polt_id,1,charindex('#',polt_id)-1)=B.[NAME]
时间:2024-06-14 03:19:10
--修改数据库,新增列并默认值为1
Alter Table shougeinfo Add CANTON_ID int not null default 1
---批量更新数据,就是把默认值改为CANTON_ID
update shougeinfo
set shougeinfo.canton_id=B.[ID] from CANTON B
where substring(polt_id,1,charindex('#',polt_id)-1)=B.[NAME]