Retrieving the GUID value of an inserted row

By Bill Graziano on 3 June 2002 | Tags: Data Types

Narayana Vyas Kondreddi submitted "This is yet another FAQ from Microsoft public SQL Server newsgroups. Lot of SQL Server developers are used to using @@IDENTITY to retrieve the value of the IDENTITY column immediately after inserting a row. We are missing that functionality when it comes to inserting rows with GUIDs as keys. Unfortunately, there's no equivalent to @@IDENTITY, when it comes to GUIDs. Here are three ideas to help you retrieve the GUID value immediately after inserting a row."

Link: Retrieving the GUID value of an inserted row