Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. ASP.NET
  4. Last Accessed Date and Time.

Last Accessed Date and Time.

Scheduled Pinned Locked Moved ASP.NET
databasesql-serversysadmin
2 Posts 2 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • L Offline
    L Offline
    Logup
    wrote on last edited by
    #1

    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

    R 1 Reply Last reply
    0
    • L Logup

      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

      R Offline
      R Offline
      robert110
      wrote on last edited by
      #2

      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

      1 Reply Last reply
      0
      Reply
      • Reply as topic
      Log in to reply
      • Oldest to Newest
      • Newest to Oldest
      • Most Votes


      • Login

      • Don't have an account? Register

      • Login or register to search.
      • First post
        Last post
      0
      • Categories
      • Recent
      • Tags
      • Popular
      • World
      • Users
      • Groups