OpenXML

Convierte un XMl a una Tabla DECLARE @xml_text VARCHAR(4000), @i INT SELECT @xml_text = '<root><person LastName="White" FirstName="Johnson"/> <person LastName="Green" FirstName="Marjorie"/> <person LastName="Carson" FirstName="Cheryl"/></root>' EXEC sp_xml_preparedocument @i OUTPUT, @xml_text SELECT * FROM     OPENXML(@i, '/root/person') WITH (LastName nvarchar(50),                         FirstName nvarchar(50))