SQL Server:如何按创建日期排序(无指定列) [英] SQL Server : how to sort by creation date with no designated column

问题描述

我在SQL Server 2012中有一个常规表，我想按记录的创建日期对特定查询中的数据进行排序.

I have a regular table in SQL Server 2012 and I want to sort the data in a certain query by creation date of the records.

问题是我没有用于保存每条记录数据的列.

The problem is I don't have a column that holds this data for each record.

没有指定的列，有没有办法做到这一点?

Is there a way of doing that without the designated column?

也许数据库中存在某种内置的创建日期信息，我可以通过某种方式访问​​它...

Maybe there is some kind of a built-in creation date information that exists in the database and I can access it somehow...

推荐答案

没有内置的行创建日期信息.

There is no built-in creation date information for rows.

有些(商业)工具有时可以从事务日志中提取该信息.这是在紧急情况下使用的功能，而不是在正常操作期间使用的功能.

There are some (commercial) tools that can sometimes extract that information from the transaction logs. That's a capability used in emergencies, not during normal operations.

这篇关于SQL Server:如何按创建日期排序(无指定列)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！