identifying recent inserted records in sql table

[yousufkhan]

i dont have any unique id in the sql table and i have inserted some records in into the table twice by mistake now i wanted to delte those newly inserted reocords any idea how delete

[KGComputers]

HI,

You may use the DELETE sql command to delete it...

Greg

[yousufkhan]

that i also know to use the delete command but i want to delete only newly added records

[si_the_geek]

Do you mean that you have created exact copies of existing records?

If so, you can't edit/delete any of the copies (the 'old' or 'new) individually, only all of them at once. As editing them will mean they are still the same as each other, that won't do you any good.. so what you need to do is delete them all, and then re-add the ones you want to keep.


Alternatively, simply do what you should have done in the first place... add a unique field to the table (due to your situation, it will need to be an Identity/AutoNumber for now), and then do your editing/deleting.