qq_32930451的博客

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