Identity functions in SQL Server - Part 35 Tamil

Опубликовано: 19 Октябрь 2024
на канале: IT Port

1,701

Subscribe to IT PORT :    / itport28

https://amzn.to/30Gy9d3

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.

Explained in Tamil