如:aa|bb,如果aa和bb是不定长的用如下语句分割他们
select x.fa,x.fb,x.fc ,x.fd ,substring(x.fd,1,(select charindex('|',y.fd) from t1 y where x.fa=y.fa and x.fb=y.fb and x.fc=y.fc)-1)
from t1 x
如:aa|bb,如果aa和bb是不定长的用如下语句分割他们
select x.fa,x.fb,x.fc ,x.fd ,substring(x.fd,1,(select charindex('|',y.fd) from t1 y where x.fa=y.fa and x.fb=y.fb and x.fc=y.fc)-1)
from t1 x