Retrieve Idenity

Lets say that you are inserting a row in a table which has an identity column.
You can retrieve the new identity using
Select @@IDENTITY