Article Link.

If you want the identity of each row to be unique, you need to create a unique index or primary key constraint on the identity column.

@@IDENTITY will give you the identity value for the last row inserted. This is fine unless the table you're inserting into has a trigger which performs an insert of its own generating another identity. How can you solve this, since you're interested in retrieving the ID for the first table?