What problem do you have? Error message? (If so what does it say) Just doesn't work? Something else? otherwise I'm just guessing what your problem might be ...
it doesnt return me anything...m passing emailId and password...using the email id and password i need to call my webservice and return the data accordingly.
I have tried the same way to invoke a webservice in a sql and i gain nul. Could anybody tell me what is the problem?
begin
set @sUrl='http://localhost:6745/WebService.asmx?op=converttodaysweb'+'&day='+convert(nvarchar,@paramd)+'&month:'+convert(nvarchar,@paramm)+'&year:'+convert(nvarchar,@paramy)+''
exec sp_OACreate 'MSXML2.XMLHTTP', @obj OUT
exec sys.sp_OAMethod @obj,'Open',null,'GET',@sUrl,false
exec sys.sp_OAMethod @obj,'send',null,''
exec sys.sp_OAGetProperty @obj,'responseXML.xml',@response OUT
SELECT @response [response]
exec sys.sp_OADestroy @obj