Y
yysun
Unregistered / Unconfirmed
GUEST, unregistred user!
SQL Server 2000 中有个非常实用的新概念 Template
A template is a well-formed XMLdo
cument containing one or more SQL statements and XPath queries.
Using a template you can:
- Specify SQL queries or XPath queries. When XPath queries are specified in the template, the mapping XML-Data Reduced (XDR) schema file against which the query is to be executed is also identified in the template.
- Specify a top-level element for the XML fragment that is returned by executing SQL or XPath queries;
thereby, making the result of executing the template in the URL a valid XMLdo
cument.
- Define parameters that can be passed to SQL statements or XPath queries.
- Declare namespaces.
- Specify an Extensible Stylesheet Language (XSL) style sheet to apply to the resultingdo
cument.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsql/ac_xml1_1c1f.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_ProjandTasksSample.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sqlxml_intromanagedclasses.asp
A template is a well-formed XMLdo
cument containing one or more SQL statements and XPath queries.
Using a template you can:
- Specify SQL queries or XPath queries. When XPath queries are specified in the template, the mapping XML-Data Reduced (XDR) schema file against which the query is to be executed is also identified in the template.
- Specify a top-level element for the XML fragment that is returned by executing SQL or XPath queries;
thereby, making the result of executing the template in the URL a valid XMLdo
cument.
- Define parameters that can be passed to SQL statements or XPath queries.
- Declare namespaces.
- Specify an Extensible Stylesheet Language (XSL) style sheet to apply to the resultingdo
cument.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsql/ac_xml1_1c1f.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sql_ProjandTasksSample.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/sqlxml_intromanagedclasses.asp