Convert XML data into row and columns format in SQL Server

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;

Leave a Reply