Read And write xml data in xml column in sqlserver

Suppose I have an entry


assetsIDs_xml  '119'

update Designs set assetsIDs_xml = ''
where ( assetsIDs_xml.exist('/root/id[text()=119]') =1 ) 



SELECT
           Columnlist
      FROM
            tableName c
      WHERE
            AND ((c.userIDs_xml.exist('/root/id[text()=sql:variable("@userID")]') = 1)  

Comments

Popular posts from this blog

IIS not work, Give error "HRESULT...." or When IIS start gives error "Already running a process on this port"

Introduction to WCF - WCF tutorial | WCF Tutorial - Windows Communication Foundation | WCF Example | WCF Sample code in asp.net 3.5 | Basic WCF Tutori