Can you call a webservice from TSQL code?

by

Yes , you can create like this

CREATE PROCEDURE CALLWEBSERVICE(@Para1 ,@Para2)
AS
BEGIN
    Declare @Object as Int;
    Declare @ResponseText as Varchar(8000);

    Exec sp_OACreate 'MSXML2.XMLHTTP', @Object OUT;
    Exec sp_OAMethod @Object, 'open', NULL, 'get', 'http://www.webservicex.com/stockquote.asmx/GetQuote?symbol=MSFT','false'
    Exec sp_OAMethod @Object, 'send'
    Exec sp_OAMethod @Object, 'responseText', @ResponseText OUTPUT
    Select @ResponseText
    Exec sp_OADestroy @Object
END

More Related Contents:

  1. Max Nbr of Months W/ No Activity in Past 12 Months
  2. SQL server query to output the data shown below
  3. Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?
  4. How do I generate a random number for each row in a T-SQL select?
  5. Combine multiple results in a subquery into a single comma-separated value
  6. Pass Dictionary to Stored Procedure T-SQL
  7. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  8. Floor a date in SQL server
  9. How to drop a table if it exists?
  10. Create a view with ORDER BY clause
  11. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  12. INSERT INTO vs SELECT INTO
  13. Possible to store value of one select column and use it for the next one?
  14. How FOR XML PATH(”) works when concatenating rows
  15. Scheduled run of stored procedure on SQL server
  16. SQL Server ORDER BY date and nulls last
  17. SQL Server variable columns name?
  18. How can I do something like: USE @databaseName
  19. What is the Oracle equivalent of SQL Server’s IsNull() function?
  20. How to determine the field value which can not convert to (decimal, float,int) in SQL Server
  21. How can I get the sum of multiple datetime values?
  22. How do you change the datatype of a column in SQL Server?
  23. Use of Begin / End Blocks and the Go keyword in SQL Server?
  24. How do you determine what SQL Tables have an identity column programmatically
  25. Ampersand (&) operator in a SQL Server WHERE Clause
  26. Avg of float inconsistency
  27. how to write number to word function in sql server [closed]
  28. How to set value to variable using ‘execute’ in t-sql?
  29. Update SQL with consecutive numbering
  30. Count number of records returned by group by

Leave a Comment