xml:
<root>
<abc>张</abc>
<def>王</def>
<jhk id="83" type="01" start="09" end="10" reason="11" />
</root>
SQL:
set @xml= '';
set @id_value = '';set @type_value = '';set @start_value= '';set @end_value= '';
set @abc_value= '';set @def_value = '';
SET @upd_temp='select @xml=xml_value from table where xml_value = ''xml''';
EXEC sp_executesql @upd_temp,N'@xml xml output',@xml output
--获取节点属性的信息
DECLARE cursor CURSOR SCROLL FOR
SELECT
C.value('@id[1]','VARCHAR(20)') AS id_value ,
C.value('@type[1]'