admin管理员组

文章数量:1353197

比如XML会视< 或 >为标记的开始结束，这时候就需要用<![CDATA[　xxxxxx　]]> 把你需要写入的结点内容括起来，如下

    <select id="PickUpCalUnit_LNGJTM" parameterClass="Hashtable">
      <![CDATA[
     SELECT  b.CalculatorUnitID ,
            b.BackupYear ,
            a.UnitID ,
            a.UnitName ,
            a.GeoID ,
            c.WorkID,
            c.CLLevelID
    FROM    dbo.T_Unit a
            INNER JOIN t_calculatorunit b ON a.unitid = b.unitid
            INNER JOIN T_LatestResult c ON a.UnitID = c.UnitID
    WHERE   a.UnitID IN (
            SELECT  UnitID
            FROM    T_LatestResult
            WHERE   WorkID = ( SELECT   MAX(a.WorkID) AS WorkID
                               FROM     T_LatestResult a
                                        JOIN T_Work b ON a.WorkID = b.WorkID
                                        JOIN DM_WorkStutas c ON b.StandardID = c.StandardID
                                                              AND b.WorkStutasID = c.WorkStutasID
                               WHERE    a.CLLevelID = 1
                                        AND b.StandardID = 1
                                        AND DATEPART(year, b.WorkYear) < $Year$
                             ) )
            AND c.WorkID = ( SELECT MAX(a.WorkID) AS WorkID
                             FROM   T_LatestResult a
                                    JOIN T_Work b ON a.WorkID = b.WorkID
                                    JOIN DM_WorkStutas c ON b.StandardID = c.StandardID
                                                            AND b.WorkStutasID = c.WorkStutasID
                             WHERE  a.CLLevelID = 1
                                    AND b.StandardID = 1
                                    AND DATEPART(year, b.WorkYear) < $Year$
                           ) 
      ]]>
    </select>


本文标签： 关键字无法识别XML

版权声明：本文标题：XML有关键字无法识别怎么办? 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/biancheng/1743864060a2552257.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。