摘要：
update TB_AreaUserDevice_Relation set OrderID = t.r from TB_AreaUserDevice_Relation rel inner join (select ROW_NUMBER()over ( partition by AreaUserCod 阅读全文
摘要：
select AreauserCode,RtuName from TB_AreaUser as tau right join TB_MaintenanceInfo inf on inf.RtuName like tau.AreaUSerName+'%' order by AreauserCode 阅读全文