Implementation of SQL SERVER push service by using MSMQ
Zhai Nai-qiang · Electronic Design Engineering · 2011
In traditional applications,clients pull data from a database.In a application that need a real-time processing and the database update cycle is a very long time,generally a short interval of polling which increase the burden on the database side is used.Using database triggers,CLR stored procedure or extended stored procedure,with the MSMQ messaging capabilities,a database push data service is implemented.