Miscellany
public text v1 · immutabledeclare @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