How to get the last generated identity column value in SQL Server – Part 8

In this video we will learn
1. Retrieve the last generated identity column value
2. Difference between SCOPE_IDENTITY(), @@Identity and IDENT_CURRENT(‘TableName’)

Text version of the video
http://csharp-video-tutorials.blogspot.com/2012/08/how-to-get-last-generated-identity.html

Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.
https://www.youtube.com/channel/UC7sEwIXM_YfAMyonQCrGfWA/?sub_confirmation=1

Slides
http://csharp-video-tutorials.blogspot.com/2013/08/part-8-retrieving-identity-column-values.html

All SQL Server Text Articles
http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html

All SQL Server Slides
http://csharp-video-tutorials.blogspot.com/p/sql-server.html

All Dot Net and SQL Server Tutorials in English
https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd

All Dot Net and SQL Server Tutorials in Arabic
https://www.youtube.com/c/KudvenkatArabic/playlists