sqlserver一次性修改多条

修改客户表 编号为 0101007002，0101007003的楼栋号  007-1-102，007-1-201

update gas_customer
set building= case
when govid=380 and customer_no='0101007002' then '007-1-102'
when govid=380 and customer_no='0101007003' then '007-1-201'
end
where
govid=380 and customer_no in (
'0101007002',
'0101007003'
)