复合sql

update select

 update bucp..Core_Flow_Opinion   set

  useruid =(select user_uid from bua..bua_user b

  where bucp..Core_Flow_Opinion.username=user_name)

where case when

 update bucp..Core_Flow_Opinion   set

  useruid =(select user_uid from bua..bua_user b

  where case when patindex('%(%',username) >0 then left(username,patindex('%(%',username)-1) else username  end =user_name)

 给opinion_nodeid赋值

update Core_Flow_Opinion

set currentnodeid=( SELECT  a.nodeid

FROM [BUCP].[dbo].[Core_Flow_Node] a

right join [BUCP].[dbo].[Core_Flow_Project] b

on a.flowid=b.flowid where Core_Flow_Opinion.projectid=b.id and Core_Flow_Opinion.currentNodeName=a.name)