2017年6月29日
sql update 代替游标写法
摘要： update TB_AreaUserDevice_Relation set OrderID = t.r from TB_AreaUserDevice_Relation rel inner join (select ROW_NUMBER()over ( partition by AreaUserCod 阅读全文
posted @ 2017-06-29 14:08 zklve2 阅读(249) 评论(0) 推荐(0)
sql 表字段模糊连接
摘要： select AreauserCode,RtuName from TB_AreaUser as tau right join TB_MaintenanceInfo inf on inf.RtuName like tau.AreaUSerName+'%' order by AreauserCode 阅读全文
posted @ 2017-06-29 13:56 zklve2 阅读(974) 评论(0) 推荐(0)