如何在将新记录插入数据库后调用webservice？ [英] How to call webservice after a new record is inserted into the database?

问题描述

亲爱的，



我写信是为了寻求帮助，要求找出我可以采取的方法，能够自动调用webserivce，无论何时新记录将添加到员工数据库表中。



我最初是通过研究创建一个从TSQL端调用URL的SQL触发器开始的，但是我没有走得太远而且这种方法看起来并不多最佳和安全，因此我正在寻求进一步的帮助。



任何帮助都会非常感激。

谢谢

解决方案

假设您没有使用SQL Express，这听起来像服务代理 [ ^ ]



Service Broker：来自SQL数据库的可伸缩Web服务调用 [ ^ ]

http://stackoverflow.com/a/11147636/124386 [ ^ ]

SQL服务r：Service Broker团队博客 [ ^ ]

Dear all,

I am writing to seek help, ask to figure out which approach I can take, to be able to automatically invoke a webserivce, whenever a new record is added into the employee database table.

I initially started by looking into creating a SQL trigger for invoke the URL from the TSQL side, however I did not get very far and this approach does not seem to much optimal and secure, hence I am seeking further assistance.

any help would be very much appreciated.
Thank you

解决方案

Assuming you're not using SQL Express, this sounds like a job for Service Broker[^] with external activation.

Service Broker: Scalable Web Service Calls From SQL Database[^]
http://stackoverflow.com/a/11147636/124386[^]
SQL Server: Service Broker Team Blog[^]

这篇关于如何在将新记录插入数据库后调用webservice？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！