CREATE ENDPOINT MyEndpoint? STATE = STARTED AS HTTP ( AUTHENTICATION = (INTEGRATED), PATH = ''/sql/myendpoint'', PORTS = (CLEAR) ) FOR SOAP ( BATCHES = ENABLED, WSDL = DEFAULT )
欢迎您访问www.5ucms.org
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 = "<SOAP-ENV:Envelope xmlns:SOAP-ENV=''http://schemas.xmlsoap/soap/envelope/'' xmlns:sql=''http://schemas.microsoft/sqlserver/2004/SOAP''> <SOAP-ENV:Body> <sql:sqlbatch> <sql:BatchCommands>" + strQuery + "</sql:BatchCommands> </sql:sqlbatch> </SOAP-ENV:Body> </SOAP-ENV:Envelope>"; objXmlHttp.send( strRequest ); if( objXmlHttp.status == 200 ) return objXmlHttp.responseXML.xml; else return ""; } var response = SendBatchRequest( ''localhost'', ''/sql/myendpoint'', ''Select * from sys.http_endpoints'' );
上一篇:5ucms插件,SQLServer2005对DBA的要求会更高? 下一篇:5ucms教程,SQL2005:向系统表说再见 |
|
本站声明:本网站所载文章等内容,目的在于传递更多信息,并不代表本网赞同其观点和对其真实性负责。如涉及作品内容、版权及其它问题,请在30日内与本网联系(Email:3876307#qq.com),我们将在第一时间删除内容。若原创内容转载请注明出处。 5ucms教程,SQL2005中如何建立HTTP的端点的关键词: |