How to get last inserted record in a table... In my table only primary key sequence is there..no timestamp and no identity columns... How can we achive this same task if we don't have the primary key sequence also....

M.Dayananthan - Make New Ideas That Make Your Work Interesting!!

Dunno if you can change the table but why not just add an IDENITY column? Saves a load of headaches...

--Jeff Moden

Though a costly solution, you may want to write a trigger on the table in question for INSERT and store the newly inserted key column's value in a separate table. And you may use that as reference to get the last inserted row.

But an Identity column will save all that, as Jeff said.

_________________________
- Vijay G
Strive for Perfection

Even then, what's the trigger going to do if you have something that inserts more than 1 row in the table? If it's an exclusive "GUI" related table where you will never have more than 1 row inserted for any given INSERT, then a trigger will absolutely do the trick... but like Vijay and I have both said now, adding an IDENTITY column will save all that.

--Jeff Moden

Yes, Trigger is not the apt solution to this (for batch/bulk inserts). When done in a batch, still OP could track only the last row inserted in the batch (not for each row inserted), when he says... _________________________
- Vijay G
Strive for Perfection

Understood... but how?... What determines the "last" row inserted in a batch without either an IDENTITY or a TimeStamp?

--Jeff Moden

Not being a smart guy here... would really like to know how to do this without an IDNETITY or a TimeStamp...

--Jeff Moden