Get last inserted id

Question

Is there any way I can get the last inserted ID if I am using SQL Server CE? I have 2 tables and when a new record is created, I want to be able to save the ID in the second table too.

Answer 1

SELECT @@IDENTITY

will retrieve the last auto-generated identity value in SQL Server.