Hi everybody..

I'm in a situation to get the last inserted rows from a table in sql server 2000. The table doesn't contains any identity or timestamp columns. I cannot able to include any addiional fields to this table.

I'm very much thankful with the hope any one suggest the solution.

with regards
Fraijo

You already have them... you just inserted them... store the primary key in the app before you insert them into a table. If, for some reason, that's just not working for you... you'll need to insert them into an empty table first (to remember what they are) and then into the final table.

Another way is to make a trigger on the table that will return the rows just inserted. That actually might be the easiest way... don't forget to SET NOCOUNT ON...

--Jeff Moden

Perhaps he could add an INSERT trigger to the table in question and record appropriate information elsewhere about the row(s) being inserted.

I'm having trouble resisting launching off onto my rant about the concept of "last" when applied to a table in a relational database. Without some sort of information on which to order the row so the concept of "last" has some meaning, the OP has a real problem.

A trigger could store the current_timestamp when the row was inserted. Ordering on that would allow "last" to have a meaning.

Jeff Mason
Custom Apps, Inc.
[email protected]

 (We must've crossed postings when I had an ephipany about the trigger like you did).

Yep... that's one of my favorite rant's as well. However, I think that in this case, the requester means "the last group of records the current session just inserted"...

--Jeff Moden

Hi Jeff Moden/Jeff Mason

I used a Datatable to insert the rows when I'm inserting the sql table (using c#, ASP.NET) so it clears my problem..

Thanks a lot for your support...

With Regards
Fraijo