DECLARE @xml nvarchar(4000) DECLARE @h int SET @xml = ' <root> <row id="1"> THIS IS SO ME DATA</row> </root>' EXECUTE sp_xml_preparedocument @h output, @xml SELECT * FROM OPENXML(@h, '//row') WITH (id int '@id', note nvarchar(2000) 'text()') execute sp_xml_removedocument @h-Mike