SQL Server 调用 WebService

declare @xmlhttp int
declare @err int
declare @Get VARCHAR(3000)
EXEC @err = sp_OACreate "MSXML2.XMLHTTP", @xmlhttp OUT --创建XMLHTTP对象
EXEC @err = sp_OAMethod @xmlhttp,'Open',NULL,'Get','  http://www.sms10000.com.cn/szdx_sdk/SMS?cmd=getmo&uid=075582980049&psw=12345','False'  --调用OPEN方法
EXEC @err = sp_OAMethod @xmlhttp,'Send',NULL,NULL; --调用SEND方法
EXEC @err = sp_OAGetProperty @xmlhttp, 'responseText',@Get output
print @Get

SELECT @Get as result

源地址：http://blog.csdn.net/sz_bdqn/article/details/4816292