Answers for "insert output identity"

SQL
0

insert output identity

DECLARE @OutputTbl TABLE (ID INT)

INSERT INTO MyTable(Name, Address, PhoneNo)
OUTPUT INSERTED.ID INTO @OutputTbl(ID)
VALUES ('Yatrix', '1234 Address Stuff', '1112223333')
Posted by: Guest on September-22-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language