Loading

Get primary key in SQLTransaction before commit it

Ajay Patel

Hello,

I am doing Insert using SqlTransaction but I need to get primary key of last Inserted table to use it in next statement. I don't want to commit the transaction before complete insert in second table. so how to get primary key in SQLTransaction before commit it

Thanks

2 Replies

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

Munesh Sharma12y ago
Accepted answer
Use SCOPE_IDENTITY() just after the INSERT

--

DECLARE @newId INT

INSERT INTO MyTable1(

Field1

)

SELECT @MyVal1

--End of Insert here

SELECT @newId = SCOPE_IDENTITY()

--Rest of the procedure
Ajay Patel12y ago
You can also get primary Key by using

SELECT IDENT_CURRENT ('table Name') AS Current_Identity;