摘要: begin update a set a.sglzbbh = b.sname+'-'+convert(char(200),(1+isnull(SUBSTRING(c.glh,CHARINDEX('-', c.glh)+1, LEN(c.glh)),0))) from workplan a join org_employee b on b.id = a.idowner join (select... 阅读全文
posted @ 2019-05-17 10:17 RainHouse 阅读(450) 评论(0) 推荐(0) 编辑