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

How do I compare all the column values based on the Partition by with ID

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