Identity functions in SQL Server - Part 35
Subscribe to IT PORT : / itport28
https://amzn.to/2RdCXn7
SQL Server Tutorial in Tamil : • SQL Server Tutorial in Tamil
SQL Server Concepts in Tamil : • SQL Server Concepts in Tamil
SQL Server Analytic Functions in Tamil : • SQL Server Analytic Functions Tamil
SQL Server Tutorial : • SQL Server Tutorial
SQL Server Concepts : • SQL Server Concepts
SQL Server Analytic Functions : • SQL Server Analytic Functions
Theses Three identity functions are used to retrieve Last Inserted identity value in SQL Server
@@IDENTITY – Returns last inserted identity value in any table in the current session.
SCOPE_IDENTITY – Returns last inserted identity value in current scope only
IDENT_CURRENT – Returns last inserted identity value for a specific table in any session and any scope.