world wide web development problems asp net php html xhtml css javascript jquery w3dproblems
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 intINSERTINTO TBL(Name, Email)OUTPUT INSERTED.ID INTO @OutputTbl(ID)VALUES ('ABC','email@gmail.com')SELECT @ID = ID FROM @OutputTbl ot
No comments:
Post a Comment