Last Accessed Date and Time.
ASP.NET
2
Posts
2
Posters
0
Views
1
Watching
-
Hi All, I want to display the last Access Date and Time of the record from the table, Every time (or) every access of that record. I need the query for that using sql server 2005.
Logu
If, in your database table, you have a field that stores the Last Access Date and Time then you will just need a select statement for e.g.
SELECT LastAccessDateTime FROM myTable WHERE myRecordID = 'SomeRecordId'If you don’t have a field that stores that value then you might want to add the field in the table and use Triggers to update that field or you could also do it programmatically. HTH Robert