如何从sql存储过程中获取xml数据 [英] How to get xml data from sql stored procedure

问题描述

创建xml的MY SQL查询，我如何在前端获取它?

MY Sql query creating xml, how could i get it in front end?

推荐答案

use myProducts  <br>
go  <br>
CREATE PROCEDURE sp_GetExplicitXML  <br>
AS  <br>
  SELECT 1 AS Tag,  <br>
    NULL AS Parent,  <br>
    c.catName as [Category!1!CatName],  <br>
    NULL as [Product!2!ProdName],  <br>
    NULL as [Product!2!Description]  <br>
  FROM categories c  <br>
UNION ALL  <br>
  SELECT 2 AS Tag,  <br>
    1 AS Parent,  <br>
    c.catName,  <br>
    p.productName,  <br>
    d.descText  <br>
  FROM categories c, products p, descriptions d  <br>
  WHERE c.catId = p.productCat AND p.productId = d.descProdId  <br>
  ORDER BY [Category!1!CatName], [Product!2!ProdName]  <br>
  FOR XML EXPLICIT

--------------------------------------------

--------------------------------------------

use myProducts  <br>
go  <br>
CREATE PROCEDURE sp_GetExplicitXML  <br>
AS

这篇关于如何从sql存储过程中获取xml数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！