XML Parse [英] XML Parse
问题描述
我需要帮助来解析
i need help to parse
XML变量,选择语句,主要是我要解析内部的数据
XML variable, select statement, mainly i want to parse data inside
< ;作用&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; / FUNCTION>
<FUNCTION /FUNCTION>
DECLARE @SQLXML XML ='< TASK>
< TASKHEAD>
&NBSP; < TASKINFO&NBSP; VERSION =" 11 QUOT; />
< / TASKHEAD>
< FUNCTION NAME =" Main" ACCESS =" private">
&NBSP; < EMAIL ACTIVITY =" send" SERVER =" XXXXX" FROM = QUOT; XXXX" TO =" YYY @" SUBJECT = QUOT; TEST" BODY = QUOT; TESTasfasfasfasf" />
< / FUNCTION>
< FUNCTION NAME =" Start" ACCESS =" private">
&NBSP; < PARAMETER NAME =" FunctionName" DESCRIPTION ="正在启动步骤的功能"亚型= QUOT;文本" />
&NBSP; < PARAMETER NAME =" StepNumber" DESCRIPTION ="即将执行的步骤编号"亚型= QUOT;数" />
< / FUNCTION>
< FUNCTION NAME =" End" ACCESS =" private">
&NBSP; < PARAMETER NAME =" FunctionName" DESCRIPTION ="结束步骤的功能"亚型= QUOT;文本" />
&NBSP; < PARAMETER NAME =" StepNumber" DESCRIPTION ="即将结束的步骤编号"亚型= QUOT;数" />
< / FUNCTION>
< FUNCTION NAME ="错误" ACCESS =" private">
&NBSP; < PARAMETER NAME =" FunctionName" DESCRIPTION ="带错误的函数"亚型= QUOT;文本" />
&NBSP; < PARAMETER NAME =" StepNumber" DESCRIPTION ="错误的步骤编号"亚型= QUOT;数" />
&NBSP; < PARAMETER NAME =" ErrorText" DESCRIPTION ="错误的文字"亚型= QUOT;文本" />
&NBSP; < PARAMETER NAME =" ErrorCode" DESCRIPTION ="错误代码"亚型= QUOT;数" />
< / FUNCTION>
<功能名称="失败" ACCESS =" private">
&NBSP; < PARAMETER NAME =" FunctionName" DESCRIPTION ="导致任务失败的功能"亚型= QUOT;文本" />
&NBSP; < PARAMETER NAME =" StepNumber" DESCRIPTION ="导致任务失败的步骤编号"亚型= QUOT;数" />
&NBSP; < PARAMETER NAME =" ErrorText" DESCRIPTION ="错误的文字"亚型= QUOT;文本" />
&NBSP; < PARAMETER NAME =" ErrorCode" DESCRIPTION ="错误代码"亚型= QUOT;数" />
< / FUNCTION>
< FUNCTION NAME =" Start" ACCESS =" private">
&NBSP; < PARAMETER NAME =" Reason" DESCRIPTION ="任务开始的原因"亚型= QUOT;文本" />
< / FUNCTION>
< FUNCTION NAME =" End" ACCESS =" private">
&NBSP; < PARAMETER NAME =" Reason" DESCRIPTION ="任务结束的原因"亚型= QUOT;文本" />
< / FUNCTION>
< / TASK>'
DECLARE @SQLXML XML= '<TASK>
<TASKHEAD>
<TASKINFO VERSION="11" />
</TASKHEAD>
<FUNCTION NAME="Main" ACCESS="private">
<EMAIL ACTIVITY="send" SERVER="xxxxx" FROM="xxxx" TO="yyy@" SUBJECT="TEST" BODY="TESTasfasfasfasf" />
</FUNCTION>
<FUNCTION NAME="Start" ACCESS="private">
<PARAMETER NAME="FunctionName" DESCRIPTION="The function that is starting the step" SUBTYPE="text" />
<PARAMETER NAME="StepNumber" DESCRIPTION="The step number that is about to execute" SUBTYPE="number" />
</FUNCTION>
<FUNCTION NAME="End" ACCESS="private">
<PARAMETER NAME="FunctionName" DESCRIPTION="The function that is ending the step" SUBTYPE="text" />
<PARAMETER NAME="StepNumber" DESCRIPTION="The step number that is about to end" SUBTYPE="number" />
</FUNCTION>
<FUNCTION NAME="Error" ACCESS="private">
<PARAMETER NAME="FunctionName" DESCRIPTION="The function with the error" SUBTYPE="text" />
<PARAMETER NAME="StepNumber" DESCRIPTION="The step number of the error" SUBTYPE="number" />
<PARAMETER NAME="ErrorText" DESCRIPTION="The text of the error" SUBTYPE="text" />
<PARAMETER NAME="ErrorCode" DESCRIPTION="The code of the error" SUBTYPE="number" />
</FUNCTION>
<FUNCTION NAME="Failure" ACCESS="private">
<PARAMETER NAME="FunctionName" DESCRIPTION="The function causing the task failure" SUBTYPE="text" />
<PARAMETER NAME="StepNumber" DESCRIPTION="The step number causing the task failure" SUBTYPE="number" />
<PARAMETER NAME="ErrorText" DESCRIPTION="The text of the error" SUBTYPE="text" />
<PARAMETER NAME="ErrorCode" DESCRIPTION="The code of the error" SUBTYPE="number" />
</FUNCTION>
<FUNCTION NAME="Start" ACCESS="private">
<PARAMETER NAME="Reason" DESCRIPTION="The reason the task is starting" SUBTYPE="text" />
</FUNCTION>
<FUNCTION NAME="End" ACCESS="private">
<PARAMETER NAME="Reason" DESCRIPTION="The reason the task is ending" SUBTYPE="text" />
</FUNCTION>
</TASK>'
推荐答案
输出格式是什么或应检索哪些数据?
What is the output format or which data should be retrieved?
>
这篇关于XML Parse的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!