Question

我需要从(......)中跟踪一次多指标类集调查表的记录变化。 NET 4.0 申请。这样做的最佳方法是什么?

更多说明。我们的会员表从第1号申请中更新。我们还制定了第2号申请,该申请应跟踪成员表,并就某些成员数据变化发出电子邮件通知。

Answer 1

如果您有一个历史表(与原表格相同的栏目加一个自动加固式电算栏),你可以追踪原表所有变动情况。您可以跟踪插入、删除和改动。使用触发器插入、更新和删除,以便把一行列入历史表。如果你不需要所有这些选择,那么就使用你确实需要的办法。

If you choose to use an IsDeleted flag in the original table, it complicates every query, and leaves your active table with lots of unneeded rows. But that can work, depending on your needs.

check out this link.. for more information.... http://www.codeproject.com/KB/database/DTS_SQLExpress.aspx

Answer 2

For DML changes: In SQL Server 2008, you have a built-in feature for this purpose: Change data capture.

For DDL changes: Starting with SQL Server 2005 you have DDL triggers, Example

Answer 3

This is what i think you need to do.

在数据更新时,在KQ表上设定一个触发点,每倍编制一个文件。

创建。

在FileWatcher的召回职能中,撰写发送电子邮件通知的编码。

Answer 4

使用开放式餐厅

// See constructor optional parameters to configure it according to your needs
var listener = new SqlDependencyEx(connectionString, "YourDatabase", "YourTable");

// e.Data contains actual changed data in the XML format
listener.TableChanged += (o, e) => Console.WriteLine("Your table was changed!");

// After you call the Start method you will receive table notifications with 
// the actual changed data in the XML format
listener.Start();

// ... Your code is here 

// Don t forget to stop the listener somewhere!
listener.Stop();

希望这一帮助。

友情链接