Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Article: Retrieving the GUID value of an inserted row!

Author  Topic 

Ask SQLTeam Question

0 Posts

Posted - 2002-06-03 : 08:35:22
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."

Article Link.


- Advertisement -