createendpoints.sql

< SQL Server2005程序设计>

USE AdventureWorks
GO
EXEC sp_reserve_http_namespace N'http://localhost:80/sql'
GO
CREATE ENDPOINT AdventureWorks 
   STATE = STARTED
AS HTTP(
   PATH = '/sql/AdventureSales', 
   AUTHENTICATION = (INTEGRATED), 
   PORTS = (CLEAR),
   SITE = 'localhost'
)
FOR SOAP (
   WEBMETHOD 'http://Adventure-Works/'.'GetStoreInfo' 
            (NAME='AdventureWorks.dbo.GetStoreInfo', 
             SCHEMA=NONE),
   WEBMETHOD 'http://Adventure-Works/'.'GetStoreContacts' 
            (NAME='AdventureWorks.dbo.GetStoreContacts', 
             SCHEMA=STANDARD),
   WEBMETHOD 'http://Adventure-Works/'.'GetStoreRecentOrders' 
            (NAME='AdventureWorks.dbo.GetStoreRecentOrders', 
             SCHEMA=STANDARD, FORMAT=ROWSETS_ONLY),
   WEBMETHOD 'GetStoreSalesYTD' 
            (name='AdventureWorks.dbo.ufnGetStoreSalesYTD'),
   BATCHES = ENABLED,
   SCHEMA = STANDARD,
   WSDL = DEFAULT,
   DATABASE = 'AdventureWorks',
   NAMESPACE = 'http://Adventure-Works/'
)
GO