DECLARE @idoc int
DECLARE @doc varchar(1000)
SET @doc ='
<data>
<row dev_id="DEI20040618200000964" dev_type="DZL2-0.7-AIII" work_pressure=".500" >
</row>
</data>'
--Create an internal representation of the XML document.
EXEC sp_xml_preparedocument @idoc OUTPUT, @doc
-- Execute a SELECT statement that uses the OPENXML rowset provider.
SELECT *
FROM OPENXML (@idoc, 'data/row')
WITH (dev_id varchar(50),
dev_type varchar(50),
work_pressure decimal(18,3))