SQL Server 行日期上次修改 [英] SQL Server row date last modified

问题描述

我的一个同事说 SQL Server 将上次修改的日期和时间保存在每条记录的隐藏列"中.我很确定他说错了什么.你能向我确认一下吗?

A colleague of mine says that SQL Server saves the date and time of last modification in a "hidden column" in each record. I am pretty sure that he said something wrong. Can you confirm this to me?

推荐答案

正如其他人所暗示的，你的同事一定是在胡言乱语，或者指的是其他东西.记录或页面的磁盘结构不包含对上次更新时间的任何引用.虽然您可以在对象级别找到有关上次更新的信息，但在记录/行级别没有此类信息可用.

As the others are hinting at, your colleague must be talking gibberish, or referring to something else. The on-disk structure for a record, or page for that sake, does not contain any references to the time of the last update. While you can find info regarding the last update at the object level, no such info is available at the record/row level.

这篇关于SQL Server 行日期上次修改的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！