This handy bit of sql code returns the last identity value inserted into an identity column in the current scope and sets its value to the parameter @ID
SET @ID = SCOPE_IDENTITY()
I found this a very useful thing to get to grips with and start using in my code. For further information on scope identity hit this msdn link