How To get Last Inserted Records Guid Uniqueidentifier

Gagan Gautam

10y4k

this is my query..

INSERT INTO Model (Id,Name,ValidationDate,NextValidationDate,DateCreated,DateUpdated,BusinessGroup,Country,UserId,StatusId,Deleted,RejectionNote)

SELECT Id,Name+'Copy',ValidationDate,NextValidationDate,DateCreated,DateUpdated,BusinessGroup,Country,UserId,StatusId,Deleted,RejectionNote FROM Model

where Id=@modelId

{Id will be Print on this section}

after inserting the record in this table i want to get Id (first Coloumn).

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

ketan borsdiya10y ago
Check below example
CREATE TABLE dbo.GuidTest (
Id uniqueidentifier NOT NULL DEFAULT NewSequentialID(),
Name varchar(20) NOT NULL
)
GO
INSERT INTO GuidTest(Name)
OUTPUT inserted.Id
VALUES('Ketan')
Gagan Gautam10y ago
Yes Ketan Plz five me response ASAP
ketan borsdiya10y ago
Means your ID column store GUID and you need last inserted guid?
Gagan Gautam10y ago
Hi Ketan ,
i am talking about for Guid Not For Simple Id
My column is Guid with Identity,
now my requirment is that ,
i want Guid for Latest inserted record in table
ketan borsdiya10y ago
Hi Gagan,
--First create table
CREATE TABLE [dbo].[TBL_TestIdentity](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [varchar](50) NULL
) ON [PRIMARY]
GO
-- Run Below Query
Insert into [TBL_TestIdentity](Name)
SELECT 'Ketan'
SELECT @@Identity
If it is not help you then explain me your problem and what you want?
Gagan Gautam10y ago
Dear Ketan can you give me example for uniqueidentifier how to get this...
ketan borsdiya10y ago
Put below sentence after insert
select @@IDENTITY
If Id have set Identity then it returns newly inserted row's ID

For Guid Uniqidentifier you may use NEWID()
Vinay Singh10y ago
Hi
check the query
Select Id,Name,ValidationDate,NextValidationDate,DateCreated,DateUpdated,BusinessGroup,Country,UserId,StatusId,Deleted,RejectionNot
from Model