I have an xml that looks like this:
<Root>
<row>
<F1>04858</F1>
</row>
</Root>
The only way I know to select from this and make it look like a select from table is this:
My question: Is there a simpler way to do that?
Thanks
<Root>
<row>
<F1>04858</F1>
</row>
</Root>
The only way I know to select from this and make it look like a select from table is this:
Code:
declare @xml xml
set @xml = <Root>
<row>
<F1>04858</F1>
</row>
</Root>
DECLARE @docHandle int
EXEC sp_xml_preparedocument @docHandle OUTPUT, @xml
select *
from OPENXML(@docHandle, N/Root/row) WITH (F1 varchar(10)F1)My question: Is there a simpler way to do that?
Thanks