Travis Laborde has a great tip on why not to use @@identity in TSQL code and use scope_identity() instead.  Quite a useful piece of information.