Identity functions in SQL Server - Part 35

Published: 15 September 2017
on channel: IT Port

483

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.

On this page of the site you can watch the video online Identity functions in SQL Server - Part 35 with a duration of hours minute second in good quality, which was uploaded by the user IT Port 15 September 2017, share the link with friends and acquaintances, this video has already been watched 483 times on youtube and it was liked by 8 viewers. Enjoy your viewing!

2,955

266