sp_configure 'show advanced options', ;

GO

RECONFIGURE;

GO

sp_configure 'Ole Automation Procedures', ;

GO

RECONFIGURE;

GO

declare @ServiceUrl as varchar()

declare @UrlAddress varchar()

--WebService地址：以http开头，结尾带斜杠，例如'http://webservice.webxml.com.cn/WebServices/MobileCodeWS.asmx/'

set @UrlAddress = 'http://webservice.webxml.com.cn/WebServices/MobileCodeWS.asmx/'

declare @FunName varchar()

--WebService中调用的方法名：例如'getMobileCodeInfo'

set @FunName = 'getMobileCodeInfo'   

--以下参数对应WebService中4个参数的[参数名]

declare @P1 varchar(),@P2 varchar()

set @P1 = 'mobileCode'

set @P2 = 'userid'

declare @P1_Value varchar(),@P2_Value varchar()

set @P1_Value = ''

set @P2_Value = ''

set @ServiceUrl = @UrlAddress + @FunName + '?' + @P1 + '=' + @P1_Value +'&' + @P2 + '=' + @P2_Value                       

Declare @Object as Int

Declare @ResponseText as Varchar()

Exec sp_OACreate 'MSXML2.XMLHTTP', @Object OUT;

Exec sp_OAMethod @Object, 'open', NULL, 'get',@ServiceUrl,'false'

Exec sp_OAMethod @Object, 'send'

Exec sp_OAMethod @Object, 'responseText', @ResponseText OUTPUT

Select @ResponseText

Exec sp_OADestroy @Object

GO