如何使用Sql Query获取xml值列的Xml节点值 [英] How Do I Get Xml Node Value of a xml valued column using Sql Query

问题描述

嗨专家我在我的桌子上有1 xml栏这样的

  <   CasteCertificate  >  
 <   AAAAAAAA  >  
 <   GGGG  >  RD1038696004993  <   / GGGG  >  
 <   TLIFileNo  >  dfug  <   / TLIFileNo  >  
 <   DDDDDDD  >  dshf <   / DDDDDDD  >  
 <   TTTTT  >  dslf <   / TTTTTgt;   
   
          < ; ApplicantFatherName  >  xcjgv <   / ApplicantFatherName  >  
 <   ApplicantCAddress1  >  cfhk <   / ApplicantCAddress1  >  
 <   ApplicantCAddress2  >  dfjkgh / < span class =code-keyword><   / ApplicantCAddress2  >  
 <   ApplicantCAddress3     /  >  kgjhdfhf <   / ApplicantCAddress3     /  > ;  
 <   ApplicantCAddressPin   >  0 <跨度class =code-keyword><   / ApplicantCAddressPin  >  
 <   / AAAAAAAA  >  
 <   / CasteCertificate  >  

如何通过使用sql查询获取地址字段值???

例如：我想要写一个像

的查询从*



选择申请人地址1，申请人地址2，申请人C地址谢谢

（Keerthi Kumar）

解决方案

您应该使用Google ...

http://msdn.microsoft.com/en-us/library/ms178030.aspx [ ^ ]

 选择 
 xmlfield.value（'  / CasteCertificate / ApplicantCAddress1'，'  varchar（max ）'） AS  ApplicantCAddress1，
 xmlfield.value（'  / CasteCertificate / ApplicantCAddress2'，'  varchar（max）'） AS  ApplicantCAddress2，
 xmlfield.value（'  / CasteCertificate / ApplicantCAddress3'，'  varchar（max）'） AS  ApplicantCAddress3 
 来自 
 表 

Hi experts i have got 1 xml column in my table like this

<CasteCertificate>
  <AAAAAAAA>
    <GGGG>RD1038696004993</GGGG>
    <TLIFileNo>dfug</TLIFileNo>
    <DDDDDDD>dshf</DDDDDDD>
    <TTTTT>dslf</TTTTTgt;

    <ApplicantFatherName>xcjgv</ApplicantFatherName>
    <ApplicantCAddress1>cfhk</ApplicantCAddress1>
    <ApplicantCAddress2>dfjkgh/</ApplicantCAddress2>
    <ApplicantCAddress3 />kgjhdfhf </ApplicantCAddress3 />
    <ApplicantCAddressPin>0</ApplicantCAddressPin>
  </AAAAAAAA>
</CasteCertificate>

How can i get Address field value by using sql query???
eg: I want to write a query like
Select ApplicantCAddress1, ApplicantCAddress2, ApplicantCAddress3 from *

thank you
(Keerthi Kumar)

解决方案

You should use Google...
http://msdn.microsoft.com/en-us/library/ms178030.aspx[^]

select 
  xmlfield.value('/CasteCertificate/ApplicantCAddress1', 'varchar(max)') AS ApplicantCAddress1,
  xmlfield.value('/CasteCertificate/ApplicantCAddress2', 'varchar(max)') AS ApplicantCAddress2,
  xmlfield.value('/CasteCertificate/ApplicantCAddress3', 'varchar(max)') AS ApplicantCAddress3
from
  Table

这篇关于如何使用Sql Query获取xml值列的Xml节点值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！