如何跟踪在 SQL Server 中自动创建/更新行的时间?

有没有办法自动告诉 SQL Server 所有表都应该有一个用于插入和更新的时间戳?

这样做可能需要大量重复性工作?

或者有其他/更有效的方法来处理事务日志吗?

解决方案

看看AutoAudit>

这会将列添加到表中并创建 DML 触发器来管理这些列以及维护审计跟踪表

我发现它非常有用

当然可以使用 DDL 触发器来尝试强制执行表设计问题.还可以自动检查元数据的设计气味

Is there a way to automatically tell SQL Server that all tables should have a timestamp for insert and update?

That's probably a lot of repetitive work to do this?

Or is there another/more efficient way to do this with the transaction log?

解决方案

Have a look at AutoAudit

This will add columns to a table and create DML triggers to manage those columns as well as maintain the audit trail table

I've found it to be very useful

It's certainly possible to use DDL triggers to attempt to enforce table design issues. It's also possible to automate checking the metadata for design smells