Home Forums SQL Server 2005 Administering How To Get Last Inserted Record Value In SQL Server RE: How To Get Last Inserted Record Value In SQL Server
Johnson Welch
SSCoach
Points: 18773
More actions
July 22, 2016 at 4:56 am
#1891525
we can use SELECT @@IDENTITY, SELECT SCOPE_IDENTITY(), SELECT IDENT_CURRENT(‘TableName’) to get last inserted record: https://mostafaelmasry.com/2016/05/09/how-to-find-the-last-inserted-record-in-sql-server/[/url]