DECLARE @x XML = '
| Medical Record No. : 1165677 | Patient Name : MASTER. SURYANARAYANAN T S | Age : 16 Year(s) | Sex : male |
window.parent.document.getElementById("imgOpenHistory").click();return false;">
Main Complaints
'
SELECT t.c.value('.', 'NVARCHAR(MAX)')
FROM @x.nodes('*') t(c)
when i run the above shows error as follows
XML parsing: line 6, character 2, whitespace expected
line 6 as follows
"onclick ="window.parent.document.getElementById("Base_pgContentHolder_pgContent_hdnScrnId").value="EMRFIRST";
window.parent.document.getElementById("imgOpenHistory").click();return false;">
Nilesh ShahPosted Dec 11, 2017, 1:13 PM
Nilesh ShahPosted Dec 11, 2017, 9:03 AM