建立一个HTTP端点是非常简单的,如下：
CREATE ENDPOINT MyEndpoint?
STATE = STARTED
AS HTTP (
AUTHENTICATION = (INTEGRATED),
PATH = ’/sql/myendpoint’,
PORTS = (CLEAR) )
FOR SOAP (
BATCHES = ENABLED,
WSDL = DEFAULT
)
在上面的案例中我建立一个命名为MyEndpoint的端点,它在http://localhost/sql/myendpoint监听T-SQL语句,你可以使用下面URL测试它
http://localhost/sql/myendpoint?wsdl.
上面这个URL还可以附加很丰富的参数,具体参见SQL帮助
下面这个例子显示如何通过JAVSCRIPT来调用端点执行T-SQL语句,如下:
function SendBatchRequest( strServerName, strUrlPath, strQuery )
{
var objXmlHttp = null;
var strRequest = "";
objXmlHttp = new ActiveXObject( "microsoft.xmlhttp" );
objXmlHttp.open( "POST", "http://" + strServerName + strUrlPath, false );
objXmlHttp.setrequestheader( "Content-Type", "text/xml" );
objXmlHttp.setRequestHeader( "Host", strServerName );
strRequest = "
xmlns:sql=’http://schemas.microsoft.com/sqlserver/2004/SOAP’>
" + strQuery + "
";
objXmlHttp.send( strRequest );
if( objXmlHttp.status == 200 )
return objXmlHttp.responseXML.xml;
else
return "";
}
var response = SendBatchRequest( ’localhost’, ’/sql/myendpoint’, ’Select * from sys.http_endpoints’ )
责任编辑：小草
