FR.remoteEvaluate("sql(\"gv\",\" update i1 set i1.serialnumber=i2.serialnumber from gv_tj_task_item i1 INNER JOIN (select convert(varchar(6),task_id)+CONVERT(varchar(100), GETDATE(), 12)+RIGHT('00000000'+CAST(convert(varchar(10),row_number()over(order by id ))as varchar(10)),4) as serialnumber,id from gv_tj_task_item where task_id='" + taskid + "' )i2 on i2.id=i1.id where i1.task_id='" + taskid + "' and i1.serialnumber ='1' \",1,1)"); |
1min目标场景问卷
立即参与
