How do I get the last Inserted / Modifed Record

Posted by Gokula*123 under Sql Server on 8/19/2010 | Points: 10 | Views : 3754 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi,

How do I get the last inserted and modified record in SQL Server 2005?

For example, I have modified the 5th record in Table1, insert 10th record in Table2, modified 8th record in Table3.

I want to know last modified / inserted record in each table

If I queried with Table1 will display 5th record has modified, Table2 will display 10th record has inserted and, Table3 will display 8th record has modified.

Regards,
Gokula

Thanks & Regards,
GokulaKrishnan Ranganathan

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Shankul2784 on: 8/19/2010 [Member] Bronze | Points: 25

0	Hi, for modification, you can add a one column where you can update the modified date & time so that it will return you the updated record. Also for created date, you can create a created date column & in default write the getdate() function so that there is no need to write any statement & you will get result. I hope, this will help you. Thanks & Regards, Shailesh Gokula123, if this helps please login to Mark As Answer*. \| Alert Moderator

Hi,

for modification, you can add a one column where you can update the modified date & time so that it will return you the updated record. Also for created date, you can create a created date column & in default write the getdate() function so that there is no need to write any statement & you will get result.

I hope, this will help you.

Thanks & Regards,

Shailesh

Gokula*123, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts