--内置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
调用