SCOPE_IDENTITY() for GUIDs?

Question

Can anyone tell me if there is an equivalent of SCOPE_IDENTITY() when using GUIDs as a primary key in SQL Server?

I don't want to create the GUID first and save as a variable as we're using sequential GUIDs as our primary keys.

Any idea on what the best way to retrieve the last inserted GUID primary key?

Answer 1

Below code will also work if you're inserting multiple records:

CREATE TABLE dbo.GuidPk (

    ColGuid uniqueidentifier NOT NULL DEFAULT NewSequentialID(),

    Col2    int              NOT NULL

)

GO

DECLARE @op TABLE (

    ColGuid uniqueidentifier

)

INSERT INTO dbo.GuidPk (

    Col2

)

OUTPUT inserted.ColGuid

INTO @op

VALUES (1)

SELECT * FROM @op

SELECT * FROM dbo.GuidPk

Note: You can get the GUID back by using OUTPUT. 

Refer to this link: Exploring SQL 2005’s OUTPUT Clause