sql server解析 xml数据类型，返回新数据列

sql server中xml数据类型解析出有用的数据
如：SO_NO='5P1611035',Batch_NO='70898746 '

select * from(
SELECT a.SO_NO,Batch_NO
FROM Cut_Plan_Auto_Task a
) t
outer apply(
select Batch_NO = N.v.value('.', 'varchar(100)') from t.Batch_NO.nodes('/root/v') N(v)
)B

结果为:
5P1611035,70898746