Another new XML-
CREATE ENDPOINT MyHTTPEndpoint STATE = STARTED AS HTTP( PATH = '/sql', AUTHENTICATION = (INTEGRATED ), PORTS = ( CLEAR ), SITE = 'server' ) FOR SOAP ( WEBMETHOD 'http://tempUri.org/'.'GetProductName' (name ='AdventureWorks.dbo.GetProductName', schema=STANDARD ), BATCHES = ENABLED, WSDL = DEFAULT, DATABASE = 'AdventureWorks', NAMESPACE = 'http://AdventureWorks/Products' )
This example illustrates creating an HTTP endpoint named MyHTTPEndPoint for the stored procedure named GetProductName in the sample AdventureWorks database. Once the HTTP endpoint is created, it can be accessed via a SOAP request issued by an application. You can use the ALTER ENDPOINT and DROP ENDPOINT DDL statements to manage SQL Server’s HTTP endpoints. The new HTTP endpoints are also able to provide data stream encryption using SSL. More information about SQL Server’s new HTTP support can be found in Chapter 2.
The follow command shows how to list the HTTP endpoints that have been created:
select * from sys.http_endpoints
While the majority of the XML enhancements in SQL Server 2005 have been implemented for the relational database engine, Analysis Services has also received several important new XML-
XML for Analysis Services is an API that provides data access to Analysis Services data sources that reside on the web. XML for Analysis Services is
XML for Analysis Services provides two
SQL Server 2005 stores information about the XML that’s used in the server in a number of new system views. Table 7-1
|
XML Catalog View |
Description |
|---|---|
|
sys.xml_attributes |
This view provides a row for each stored XML attribute. |
|
sys.xml_components |
This view provides a row for each component of an XML schema. |
|
sys.xml_component_placements |
This view provides a row for each placement of an XML component. |
|
sys.xml_elements |
This view provides a row for each XML component that is an XML element. |
|
sys.xml_facets |
This view provides a row for each facet (restriction) of an XML type. |
|
sys.xml_model_groups |
This view provides a list of all the XML component that are part of a Model-
|
|
sys.xml_namespaces |
This view provides a row for each XSD-defined namespace. |
|
sys.xml_types |
This view provides a row for each XML component that is an XML type. |
|
sys.xml_wildcards |
This view provides a row for each XML attribute or element wildcard. |
|
sys.xml_wildcard_namespaces |
This view provides a row for each XML wildcard namespace. |