Whenever a record is inserted or updated in the sql server table, I have to call a third-party service that will insert / update their table. What is the most efficient way to do this?
SQL server trigger to call .Net (I'm not sure if this is possible ... Is it possible to send a record identifier to a .NET application with every insert / update?)
An application that continuously checks changes to a table using the select statement receives a specific record -> send through service.
Something else?
SQL Server 2005 CLR, , .Net, , SQL. , , insert, @@IDENTITY , CLR, . NET/
- ,
.