SQL Server @@Identity vs Scope_Identity vs Ident_Current. Click here to Subscribe to IT PORT Channel : https://www.youtube.com/channel/UCMjmoppveJ3mwspLKXYbVlg
Identity is a Column Property. This Property is used with CREATE TABLE and ALTER TABLE Transact SQL Statements.
When you insert a new record into your table, this field automatically assign an incremented value from the previous entry. Usually, you can't insert your own value to this field.
You must specify both the seed and increment or neither. If neither is specified, the default is (1,1).
We Can Get the Inserted Identity value by using these three Functions.
In this Video you can check these functions with Simple Example
Tags: SQL Server @@Identity vs Scope_Identity vs Ident_Current, SQL Server Identity, SQL Server @@Identity, SQL Server Scope_Identity, SQL Server Ident_Current, @@Identity vs Scope_Identity vs Ident_Current, SQL Server Tutorials, SQL Server Tips & Tricks