We can select the recent row enrtered by using the query below.
suppose the table name is employee;
then.

select * from employee where rowid=(select max(rowid) from employee).

This works fine because rowid is assigned for each and every record and in accending order. So the recent record’s rowid is the man (rowid). Please send feedback with any concern
or

You can check it with the help ofSCOPE_IDENTITY( ) function in SQL server 2000 or 2005.

Advertisements