在Sql server2005中创建内置 WebService

 --内置webservice
CREATE ENDPOINT SQLWebservice
STATE = STARTED
AS HTTP(
   PATH = '/sql',
   AUTHENTICATION = (INTEGRATED ),
   PORTS = ( CLEAR ),
   SITE = 'localhost'
   )
FOR SOAP (
  
   WEBMETHOD 'DayAsNumber'
            (name='testdb.dbo.highwaydevicealert'),
   WSDL = DEFAULT,
   SCHEMA = STANDARD,
   DATABASE = 'testdb',
   NAMESPACE = 'http://tempUri.org/'
   );
GO

 

调用

http://localhost/sql?WSDL