SQL Server - What is the date/time of the last inserted row of a table?
12,046
It depends on the version of SQL server you're using. SQL server 2005 or newer you try looking here. If its an older server engine you may be out of luck unless someone was proactive enough to use stored procedures and logged updates.
Related videos on Youtube
15 : 26
DateTime functions in SQL Server Part 25
14 : 52
Practice Activity - Retrieving the last row for each group in a table in SQL Server
21 : 29
DatePart, DateAdd and DateDiff functions in SQL Server Part 27
03 : 32
How to Fetch Latest record/row from the Table in Oracle Database
11 : 01
52. How to Use Date Data Type in SQL Server
04 : 23
Check Last Modified DateTime for An Object (Table,Stored Procedure,Trigger etc.) in SQL Server
18 : 33
Work with datetime in sql server
19 : 31
SQL Server DATETIME, DATE and TIME data types | Manipulating Dates, times and Strings | SQL basics
Author by
Nick Patterson
Updated on June 04, 2022Comments
-
Nick Patterson almost 2 years
My fellow programmers did not think to add timestamps to every tables of our outstanding database.
As a result, some tables seem to be outdated, but it is very difficult to say which ones.
Is there any way to get, for each table, the date/time of the last insert command performed against it?
-
Nick Patterson about 15 yearsI'm in luck, i'm using SQL Server 2005 ! :o) Thanks for the link.