Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Get last ID from table
- Thread starter EscapeUK
- Start date
If it is an Identity column, then you can query @@Identity to get the value of the most recent insert operation for the current connection. It does not work retroactively (you can't go back a day later and ask for the last Identity value for a give table).
Alternatively, you can use
SELECT MAX(MYCOLUMN) FROM MYTABLE
Technically, it won't give you the last entered value, only the highest. Robert Bradley
Got extra money lying around? Visit:
Alternatively, you can use
SELECT MAX(MYCOLUMN) FROM MYTABLE
Technically, it won't give you the last entered value, only the highest. Robert Bradley
Got extra money lying around? Visit:
- Status
Similar threads
- Locked
- Question