用sql替换T6工作流中的操作员

/*修改下面语句中的汉字*/

declare @colduser_id varchar(200)

declare @cnewuser_id varchar(200)

 

set @colduser_id='原来的操作员编码'

set @cnewuser_id='现在的操作员编码'

 

update EA_auditPerson set cUser_id=@cnewuser_id  where cUser_id=@colduser_id

update EA_stream_task set submit_from=@cnewuser_id where  submit_from=@colduser_id

update EA_stream_task set SubMit_To=@cnewuser_id where  SubMit_To=@colduser_id