Appropriate use of `IDENTITY` in TSQL

Question

Possible duplicate:
Best way to get the ID of an inserted row?

When is this appropriate and how should someone use a different keyword IDENTITYin T-SQL?

• SELECT @@ IDENTITY,
• SELECT SCOPE_IDENTITY ()
• SELECT IDENT_CURRENT ('tablename)

Answer 1

See SQL SERVER - @@ IDENTITY vs SCOPE_IDENTITY () vs IDENT_CURRENT - Get the last inserted record identity

From the article

SELECT @@ IDENTITY

IDENTITY , , , . @@IDENTITY , . @@IDENTITY , . , , , , , .

SELECT SCOPE_IDENTITY()

IDENTITY , , . SCOPE_IDENTITY(), @@IDENTITY, , , . , , - .

SELECT IDENT_CURRENT ('tablename)

IDENTITY , , , . IDENT_CURRENT ; . IDENT_CURRENT , .

Answer 2

MSDN .

, @@IDENTITY - ( IDENTITY INSERT, , , , IDENTITY).

SCOPE_IDENTITY() , , .

IDENT_CURRENT - , ( , )