A、创建包含简单Select语句的模板文件。
<?xml version="1.0" encoding="UTF-8"?>
<root xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<sql:query>
select top 10 customerid,companyname from customers for xml auto
</sql:query>
</root>
该模板在文件(temp.xml)中并通过URL执行:http://localhost/template/temp.xml,结果如下:
<?xml version="1.0" encoding="UTF-8" ?>
-<root xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<customers customerid="ALFKI" companyname="Alfreds Futterkiste" />
<customers customerid="ANATR" companyname="Ana Trujillo Emparedados y helados" /> <customers customerid="ANTON" companyname="Antonio Moreno Taquería" />
<customers customerid="AROUT" companyname="Around the Horn" />
</root>
B、在模板文件中执行存储过程。
在SQL Server建一存储过程CategoryInfo:
if exists (select name from sysobjects where
name="CategoryInfo" and type="P"
Drop procedure CategoryInfo
GO
CREATE PROCEDURE dbo.CategoryInfo
AS
Select CategoryID,CategoryName from Categories where
Categories.CategoryID=2 for xml Auto
该模板存储在文件(temp1.xml)中并通过URL执行:http://localhost/template/temp1.xml,结果如下:
<?xml version="1.0" encoding="UTF-8" ?>
-<root xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<Categories CategoryID="2" CategoryName="Condiments"/>
</root>