All pastes #2118502 Raw Edit

Miscellany

public text v1 · immutable
#2118502 ·published 2012-02-17 13:37 UTC
rendered paste body
declare @xml xml,@i int

SELECT  @xml = CAST(x AS XML) FROM OPENROWSET(BULK 'C:\1.xml',SINGLE_BLOB) AS T(x)

exec sp_xml_preparedocument @i OUTPUT,@xml


SELECT * FROM OPENXML(@i,'/root/Application/jre') WITH (o varchar(100) '@atribut')

exec sp_xml_removedocument @i