34,588
社区成员
发帖
与我相关
我的任务
分享
select T.C.value('xm[1]','varchar(20)') as xm,
CAST (case when T.C.value('xb[1]','varchar(20)')='' then 0
else T.C.value('xb[1]','varchar(20)') end as numeric(8,0))as xb
from @lxml_str.nodes('//rtcffx') as T(C)