How To get Last Inserted Records Guid Uniqueidentifier

Question

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).

ketan borsdiya · Answer

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 Gautam · Answer

Yes Ketan Plz five me response ASAP

ketan borsdiya · Answer

Means your ID column store GUID and you need last inserted guid?

Gagan Gautam · Answer

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 borsdiya · Answer

Hi Gagan --First create table CREATE TABLE [dbo].[TBL_TestIdentity]( [Id] [int] IDENTITY(11) 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 Gautam · Answer

Dear Ketan can you give me example for uniqueidentifier how to get this...

ketan borsdiya · Answer

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 Singh · Answer

Hi check the query Select IdNameValidationDateNextValidationDateDateCreatedDateUpdatedBusinessGroupCountryUserIdStatusIdDeletedRejectionNot from Model