本文介绍了使用分隔符在SQL Server中分割字符串的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
My string is as below :
<pre>'<SL1> Locationdetails are in the table .<RXCH><cF7712>Location1<cF4712>
<RXCS1>H1<RXCS2>H2<RXCS3>H3
<RXC11>C11<RXC12>C12
<RXC13>C13<RXC21>C21
<RXC22>C22<RXC23>C23
<RXC31>C31<RXC32>C32
<RXC33>C33<RXC41>C41
<RXC42>C42<RXC43>C43
<RXC51>C51<RXC52>C52
<RXC53>C53
<RXCH><cF7712>Location2<cF4712>
<RXCS1>H1<RXCS2>H2<RXCS3>H3
<RXC11>C11<RXC12>C12
<RXC13>C13<RXC21>C21
<RXC22>C22<RXC23>C23
<RXC31>C31<RXC32>C32
<RXC33>C33<RXC41>C41
<RXC42>C42<RXC43>C43
<RXC51>C51<RXC52>C52
<RXC53>C53. Services for primary health care'
OUTPUT should be ::
'Location1 H1 H2 H3 C11 C12 C13 C21 C22 C23 C31 C32 C33 C41 C42 C43 C51 C52 C53 Location2 H1 H2 H3 C11 C12 C13 C21 C22 C23 C31 C32 C33 C41 C42 C43 C51 C52 C53'推荐答案
这篇关于使用分隔符在SQL Server中分割字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！