master..spt_values

1
2
3
4
5
6
select 
t.number,
dl_office=substring(c.RQFLMC,t.number,charindex(';',c.RQFLMC+';',t.number)-t.number),c.RQFLMC
 from API_QY_RQFL c 
join master..spt_values t on t.type='P'
where  charindex(';',';'+c.RQFLMC,t.number)=t.number

substring(c.RQFLMC, t.number, charindex(‘;’,c.RQFLMC+’;’,t.number)-t.number)
拆分字段数据

master..spt_values.number [0-2047]
join 循环拆分数据条数

类型转换

CAST(‘字段名’ as 类型)
CONVERT(类型，’字段名’)