如何在SQL Server中使用存储过程导出XML? [英] How to export XML using stored procedure in SQL server?
问题描述
大家好,
我对我的sql程序有一些说明。
我的情景是,
我有一个预期的输出样本xml格式。
i想要根据样本xml创建存储过程并导出到下面的xml格式。
当我执行存储过程时我需要获得以下输出,
i已经尝试了这个但是我无法获得输出。
所以请给我一个解决方案。
xml格式:
Hi All,
I have some clarification about my sql procedure.
MY scenario is,
I have one expected output sample xml format.
i want to create stored procedure based on the sample xml and export to the below xml format.
when i execute the stored procedure i need to get the below output,
i have tried this but i couldn't get the output.
So please drop me a solution for this.
xml format:
<MAIN>
<Data>
<getdate>13.06.2016</getdate>
<Doc>
<phone>1234</phone>
</Doc>
</Data>
</MAIN>
提前感谢。
< b>我尝试了什么:
如何使用sql server中的存储过程导出xml?
thanks in advance.
What I have tried:
how to export xml using stored procedure in sql server?
推荐答案
从这个资源列表 [ ^ ]
试一试如果你还有问题,请回来代码y你有
Start with this list of resources[^]
Give it a try and if you are still having problems come back with the code you are having problems with
这篇关于如何在SQL Server中使用存储过程导出XML?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!