How to insert date and time stamp using trigger when i am executing select query to any database table row


  • Suppose a table name ABC . ABC table has two rows name row1 and row2. now if any any execute select query to ABC table any row, then i need to track select query execution date time stamp. Example  : suppose  now 24sep 2013: 11.45PM. just this time some execute  select query on table ABC in row1, in this moment i want to save table name row name and selection date time stump(that means :table ABC,row1,24sep 2013:11.45PM)
    Tuesday, September 24, 2013 5:48 PM


All replies