SQL 拆分字符串(with写法)
create table table1(Name varchar(50), Grade int)
insert into table1 values(‘张三,李四,王五’, 1)
insert into table1 values(‘赵六,孙七,周八’, 2)
insert into table1 values(‘吴九’, 3)
–必须以’,'结尾,否则无法截取最后一个名字
update table1 set Name = Name + ‘,’
with t as(
select Name, CHARIND
原创
2020-09-30 11:28:27 ·
190 阅读 ·
0 评论