T-SQL 101: #132 Identifying the Last Value Inserted with Identity Columns in SQL Server - The Bit Bucket

https://blog.greglow.com/2025/03/20/t-sql-101-132-identifying-the-last-value-inserted-with-identity-columns-in-sql-server/