Tuesday, August 12, 2014

How do I use an INSERT statement's OUTPUT clause to get the identity value?

DECLARE @OutputTbl TABLE (ID INT)
 
DECLARE @ID int
 
INSERT INTO TBL(Name, Email)
OUTPUT INSERTED.ID INTO @OutputTbl(ID)
VALUES ('ABC', 'email@gmail.com')
 
SELECT @ID = ID FROM @OutputTbl ot