sql server 2005生成xml
运行:sql2005中的Configure SQL XML Support in IIS (到MS网站上下载SQLXML 22.0 SP3:
http://www.microsoft.com/downloads/details.aspx?FamilyID=51D4A154-8E23-47D2-A033-764259CFB53B&displaylang=en)
设置一个虚拟目录,setting中允许sql=URL查询
浏览器中:http://localhost/Northwind?sql=select+top+5*+from+customers+for+xml+auto&root=ROOT
http://www.microsoft.com/downloads/details.aspx?FamilyID=51D4A154-8E23-47D2-A033-764259CFB53B&displaylang=en)
设置一个虚拟目录,setting中允许sql=URL查询
浏览器中:http://localhost/Northwind?sql=select+top+5*+from+customers+for+xml+auto&root=ROOT
