How to Call A web service inside SQL server
-
Hello . I have a web service which takes some parameters and inserts them in another database . I have my own database that has a table (Table_B) .Now I want to call my web service when a new record inserts to (Table_B) I know that i should use a trigger . All I want to do is calling a web service inside of my trigger . I don't know how to call it. Would you please help me Thanks . bye
-
Hello . I have a web service which takes some parameters and inserts them in another database . I have my own database that has a table (Table_B) .Now I want to call my web service when a new record inserts to (Table_B) I know that i should use a trigger . All I want to do is calling a web service inside of my trigger . I don't know how to call it. Would you please help me Thanks . bye
If I was you I would start here: www.google.com[^] Type sql server call web service from trigger and press Enter. That gives over 2 million links, at least one of them must be useful. P.S. one of those links is to an article here on Code Project. In the article it actually says:
The truth is it's not good to access a web service trought a trigger, due to performance concerns.
I'm sure you can make your own mind up as to whether that is true or not.
-
If I was you I would start here: www.google.com[^] Type sql server call web service from trigger and press Enter. That gives over 2 million links, at least one of them must be useful. P.S. one of those links is to an article here on Code Project. In the article it actually says:
The truth is it's not good to access a web service trought a trigger, due to performance concerns.
I'm sure you can make your own mind up as to whether that is true or not.
Hi Thanks for your Guidance. I know all of them but thanks
-
Hello . I have a web service which takes some parameters and inserts them in another database . I have my own database that has a table (Table_B) .Now I want to call my web service when a new record inserts to (Table_B) I know that i should use a trigger . All I want to do is calling a web service inside of my trigger . I don't know how to call it. Would you please help me Thanks . bye
If I may ask, what inserts records in table_B; is it a stored procedure? If so, I would use the same stored procedure to call the web service immediately after it inserts data. I don't know if ordinary stored procedures can call web services so I would suggest an extended stored procedure i.e. a CLR dll. I haven't done anthing like it; so I am really just guessing.