基于服务代理数据库间的消息传递

某公司的管理层想知道在一年的任何点的确切的年销售以帮助他们计划未来的策略。集合年销售数据是存储在TotalsalesDB数据库中。销售事务详情被存储在SalesDB数据库中。为了保持的销售数据更新，需要确保无论何时任何定单被处理和在SalesDB数据库中交货日期被更新的时候，定单的总钱数，应该被添加到TotalSalesDB数据库的总年销售中。为了解决上述问题，需要在数据库中实现服务代理。该文详细解释了如何通过服务代理完成上述任务。

Message Passing between Databases Based on Service Broker

A management of a company would like to know the exact year of any point of the annual sales to help them plan for the future strategy.Collection of annual sales data is stored in the TotalSalesDB database.Sales transaction details are stored in the SalesDB database.In or-der to maintain sales data updated whenever the need to ensure that any orders are processed and SalesDB database is updated when the de-livery date,the total amount of money orders,should be added to the database TotalSalesDB total annual...