Sql Server 存储过程 解析 XML

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]'