Retreive last inserted record in sql

Question

0.00/5 (No votes)

See more:

I need a query by which I can get to know that when I insert a record in the table suppose I insert the 5 record in the table I can retrieve the same, how can I do so in sql server 2005?

Posted 1-Nov-12 8:15am

lalitkr

Updated 1-Nov-12 8:21am

Kschuler

v2

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Arunprasath Natarajan · Answer 1 · 2012-11-01T18:03:00

Solution 2

I second what Solution 1 was.
Here is link which is similar to question and its solution

I want a sql query for latest 25 rows[^]

Posted 1-Nov-12 18:03pm

Arunprasath Natarajan

**Manoj K Bhoir** · Answer 2 · 2012-11-01T18:18:00

Add One More Column To Your SQL Table sNO With DataType Numeric(18,0) And Identity Specification Yes. If Your Table Already Contain Column Like this then Use this Column insted of sNO Then Use Following SQL Query :

SQL

SELECT TOP(1) * FROM TABLENAME ORDER BY sNO DESC

I hope it will help you. :)

damodara naidu betha · Answer 3 · 2012-11-01T19:02:00

Solution 4

This link can help you

http://blog.sqlauthority.com/2007/10/01/sql-server-2005-output-clause-example-and-explanation-with-insert-update-delete/

Posted 1-Nov-12 19:02pm

damodara naidu betha

Updated 1-Nov-12 19:03pm

v2

Corporal Agarn · Answer 4 · 2012-11-01T08:20:00

Solution 1

If you are using SQL Server you would need a time-stamp column or an incremental column.
Other database servers may have this build in.

Posted 1-Nov-12 8:20am

Corporal Agarn