需求:
将a表的nvc_add_name
字段设置为b表的nvc_show_name
值,其中b.nvc_admin_name = a.nvc_add_name
,且a表的i_ed_identifier
取值为2或3:
update a set a.nvc_add_name = b.nvc_show_name from Information.dbo.t_equipment_manage a inner join GYBTest.dbo.t_admin_info b on b.nvc_admin_name = a.nvc_ad