createnwindendpoint.sql

来自「wrox出版社的另一套经典的VB2005数据库编程学习书籍,收集了书中源码,郑重」· SQL 代码 · 共 35 行

USE Northwind
GO
IF (SELECT COUNT(*) FROM sys.endpoints WHERE name='NorthwindEP') > 0
DROP ENDPOINT NorthwindEP
GO

CREATE ENDPOINT NorthwindEP
STATE = STARTED
AS HTTP(
   PATH = '/wsnwindep', 
   AUTHENTICATION = (INTEGRATED), 
   PORTS = (CLEAR), 
   SITE = 'localhost', 
   COMPRESSION = ENABLED
   )
FOR SOAP (
   WEBMETHOD 'TenMostExpensiveProducts' 
      (NAME = 'Northwind.dbo.[Ten Most Expensive Products]', 
       FORMAT = ROWSETS_ONLY, SCHEMA = STANDARD),
   WEBMETHOD 'SalesByCategory' 
      (NAME='Northwind.dbo.SalesByCategory',
       FORMAT = ROWSETS_ONLY, SCHEMA = STANDARD),
   WEBMETHOD 'EmployeeSalesByCountry' 
      (NAME='Northwind.dbo.[Employee Sales by Country]',
       FORMAT = ROWSETS_ONLY, SCHEMA = STANDARD),
   WEBMETHOD 'CustomerOrderHistory' 
      (NAME='Northwind.dbo.CustOrderHist', 
       FORMAT = ROWSETS_ONLY, SCHEMA = STANDARD),
   BATCHES = ENABLED,
   WSDL = DEFAULT,
   DATABASE = 'Northwind',
   NAMESPACE = 'http://oakleaf.ws/webservices/northwindep',
   SCHEMA = STANDARD
   ) 
GO