08 2023 档案

Sqlserver 插入查询的数据
摘要：记录用UPDATE XXXSET w_apply_num = (select (CASE a.dot WHEN 10 THEN CONCAT('CN',a.num,'.','X') ELSE CONCAT('CN',a.num,'.',a.dot) END) as dots FROM(select 阅读全文
posted @ 2023-08-15 13:05 IT_小树 阅读(97) 评论(0) 推荐(0)