|
Hi, can anyone let me know how to fetch/get last inserted row in sql server. Table have NO Primary key, Identity, it has only one column 'Employee Name'.
(comments are locked)
|
|
You can't get it as there is no way to tell it was the last inserted, either add a primary key or a date added field.
(comments are locked)
|
|
You can not fetch data while there is no primary key you should add one primary key or date time field. Yes you can fetch data, you just can't guarantee the order of that data if you are looking for it in this way. You can order it however you want, by checksum(), alphabetically etc.. You just can't tell when it was added to the table.
Apr 26 '10 at 10:44 AM
RickD
(comments are locked)
|
Your answer
