@@IDENTITY contains the last identity value that is generated by a statement in MSSQL. It is a question for DBAs. I don't know why I was asked this question. I guess to see overall how technical I am. I was also asked network questions.