I need result like that
DECLARE @XML XML SELECT @XML =' <tr> <td>Name</td> <td>Date</td> <td>Status</td> <tr> <tr> <td><content ID="material-5570">Chetan</content></td> <td>07/22/2016</td> <td>Current</td> </tr> ';
Column1 Column2 ----------- ------------ Name Chetan Date 7/22/2016 Status Current
Hello guys, i have xml file that have value and value contain double qoat in that xml is given below please help me select data from that.
DECLARE @XMLstr AS NVARCHAR(MAX)
SELECT @XMLstr =
DECLARE @xml XML
SELECT @xml = CAST(REPLACE(@XMLstr, '''', '''''') AS XML)
SELECT @xml FOR XML PATH('')
actually i wants to store quote in table "2/2018 Just like we store height foot and inch 5'6 like that "2/2018 please help me.
23 People are following this question.