以下為範例:

INSERT INTO report_temp_data
(report_id,report_data)VALUES('<row>

<IdInvernadero>8</IdInvernadero>

<IdProducto>3</IdProducto>

<Name>Fred</Name>

</row>

<row>

<IdInvernadero>81</IdInvernadero>

<IdProducto>13</IdProducto>

<Name>Alan</Name>

</row>')

SELECT * FROM report_temp_data

SELECT *
, report_data.value('(/row/IdInvernadero)[1]','int') AS IdInvernadero
, report_data.value('(/row/IdProducto)[1]','int') AS IdProducto
, report_data.value('(/row/Name)[1]','nvarchar(50)') AS [Name]
FROM report_temp_data
WHERE report_id='test'