sql中某一个字段内容为用逗号分割的字符串转换成多条数据并附Id
摘要：
WITH testtb2 AS ( SELECT A.ID, A.VALUE, CHARINDEX(',', A.VALUE) AS STA, CHARINDEX(',', A.VALUE) - 1 AS LENS FROM @table1 AS A UNION ALL SELECT ID, VAL 阅读全文
posted @ 2020-03-02 18:57 哦呵呵G 阅读(1686) 评论(0) 推荐(0) 编辑
