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 )