tailieunhanh - Microsoft SQL Server 2005 Developer’s Guide- P28

Microsoft SQL Server 2005 Developer’s Guide- P28:SQL Server 2005 is a feature-rich release that provides a host of new tools and technologies for the database developer. This book is written to help database developers and DBAs become productive immediately with the new features and capabilities found in SQL Server 2005. | Chapter 7 Developing with XML 249 also supported. The PORTS keyword specifies the TCP IP port that will be used. Supported vales are CLEAR default 80 or SSL default port 443 . CLEAR is used to respond to HTTP requests while SSL requires HTTPS. Finally the SITE keyword specifies the name of the host SQL Server system. The FOR SOAP clause describes the Web service. The WEBMETHOD keyword specifies the name of the Web method that will be executed by the Web service. The name keyword is used to link the Web method to the stored procedure on the SQL Server system. In this example when the Web Service GetManagers method is executed it will in turn call the uspGetEmployeeManagers stored procedure in the AdventureWorks database. The FORMAT key indicates the type of results that will be returned by the Web service. Support values are ALL RESULTS and ROWSETS_ ONLY. If you want the client system to be able to consume the results of the Web service as a dataset then you must specify the value of ROWSETS_ONLY. While this example uses a single Web method you can specify multiple Web methods per endpoint. The WSDL keyword indicates whether the endpoint supports WSDL. The value of DEFAULT means that WSDL is supported. NONE indicated WSDL is not supported. Alternatively you can provide a stored procedure name to implement a custom WSDL. The SCHEMA keyword specifies whether an inline XSD schema will be returned for the Web method. Supported values are NOE and SCHEMA. The DATABASE keyword specifies the name of the default database. The NAMESPACE keyword is used to supply a namespace for the endpoint. Once the HTTP endpoint is created it can be accessed via a SOAP request issued by an application. You can list the SOAP endpoints that have been created by displaying the contents of the system view. select from 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 .