What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?

What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?

sql sql-server identity

sql

SQL Server 2012 column identity increment jumping from 6 to 1000+ on 7th entry [duplicate]

sql sql-server sql-server-2012 identity

sql

How to insert into a table with just one IDENTITY column?

sql sql-server identity

sql

@@IDENTITY, SCOPE_IDENTITY(), OUTPUT and other methods of retrieving last identity

sql sql-server tsql identity output-clause

sql

Database-wide unique-yet-simple identifiers in SQL Server

sql sql-server database database-design identity

sql

SQL server identity column values start at 0 instead of 1

sql sql-server sql-server-2005 identity auto-increment

sql

Getting new IDs after insert

sql sql-server insert identity

sql

Handling identity columns in an "Insert Into TABLE Values()" statement?

sql sql-server database tsql identity

sql

SQL Server Reset Identity Increment for all tables

sql identity reset

sql

How to insert into a table with just one IDENTITY column (SQL Express)

sql visual-studio tsql sql-server-express identity

sql

Avoiding concurrency problems with MAX+1 integer in SQL Server 2008... making own IDENTITY value

sql locking identity max increment

sql

How can I set a Microsoft SQL field as identity but to START with a certain number?

sql sql-server identity

sql

How do I return a new IDENTITY column value from an SQLServer SELECT statement?

sql sql-server tsql identity auto-increment

sql

Inserting Data with Identity_Insert is ON with Insert into Table1 Select * from Table2

sql identity

sql

mysql update a column with an int based on order

mysql sql sql-order-by identity

sql