从表中选择最近更新的行 [英] select a row from table which is recently updated

问题描述

你好先生，

我需要选择一条最近更新的记录.

在此先感谢..........

hello sir,

i need to select a record which is updated recently.

thanks in advance..........

推荐答案

尝试一下

try this

select Object_name(Object_Id) as  DaTabaseName,last_User_Update,* from sys.dm_db_index_Usage_Stats
where DataBase_Id = DB_Id('YourDataBase') and Object_Id= Object_Id('Tabll1')

这篇关于从表中选择最近更新的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！