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 )
assetsIDs_xml '
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
Post a Comment