示例表:
需要按照’,'进行分割class字段
语句如下:
select split.name,
class=substring(class+',',number,charindex(',',class+',',number)-number
示例表:
需要按照’,'进行分割class字段
语句如下:
select split.name,
class=substring(class+',',number,charindex(',',class+',',number)-number