XML Shredding in SQL Server for present in table format
Present the XML data in table format as follows:
--Convert xml data into row and columns format
--- XML Shred ---
DECLARE @v_rawXML varchar(1000);
DECLARE @v_XMLinMemory int;
SET @v_rawXML =
'<Employee>
<FirstName>RAKESH</FirstName>
<LastName>KUMAR</LastName>
</Employee>';
EXEC sp_xml_preparedocument @v_XMLinMemory OUTPUT, @v_rawXML;
SELECT *
FROM OPENXML (@v_XMLinMemory, '/Employee', 2)
with(FirstName varchar(100),
LastName varchar(100) )
exec sp_xml_removedocument @v_XMLinMemory;