update [Business_TasksAffirm] SET driver_name=b.driver_name,PictureId=b.PictureId,iJsDoneState=1,iSIncluded=1,iSWages=1,UserId=b.UserId,UserName=b.UserName,AuditTime=b.AuditTime,cExDescription=b.cExDescription from [表] a left join openrowset( 'SQLOLEDB', '服务器地址'; '账号'; '密码',[数据库].dbo.表]) b on a.task_code = b.task_code where b.iJsDoneState=1
标签：UserName,code,driver,UserId,查询,SQL,服务器,PictureId From： https://www.cnblogs.com/netcs/p/17349259.html