使用模板执行SQL查询

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>