Get last entered id

Question

Is there a way to get the last inserted id if I use SQL Server CE? I have 2 tables, and when a new record is created, I also want to save the identifier in the second table.

Answer 1

I hope this example helps you.

INSERT INTO jobs (job_desc,min_level,max_level) VALUES ('A new job', 25, 100); SELECT job_id FROM jobs WHERE job_id = @@IDENTITY; 

Answer 2

 SELECT @@IDENTITY 

will retrieve the last automatically generated authentication value in SQL Server.

Answer 3

Assuming higher id values ​​are always newer, how about:

 SELECT TOP 1 id FROM your_table ORDER BY id DESC 

or

 SELECT MAX(id) FROM your_table 

Answer 4

use this query:

 INSERT INTO Persons (FirstName) VALUES ('Joe'); SELECT ID AS LastID FROM Persons WHERE ID = @@Identity; 

or you can view this link for more information: http://blog.sqlauthority.com/2007/03/25/sql-server-identity-vs-scope_identity-vs-ident_current-retrieve-last-inserted-identity-of -record /

Answer 5

It worked great for me

 SELECT TOP (1) your_id FROM your_table ORDER BY your_id DESC