Answers for "insert into select from where out inserted.id"

sql insert inserted id

-- Never use @@identity or scope_identity()
-- they can not always be relied upon

DECLARE @Ids_tbl TABLE ([id] INT); -- Requires table. use variable for scope
INSERT INTO [sometable] ([ColA],[ColB])
OUTPUT INSERTED.ID INTO @Ids_tbl(id)
VALUES ('valA','valB');

SELECT [id] FROM @Ids_tbl; -- <-- Id(s) in here

Posted by: Guest on May-15-2020

Code answers related to "insert into select from where out inserted.id"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "insert into select from where out inserted.id"

Code answers related to "insert into select from where out inserted.id"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "insert into select from where out inserted.id"

Code answers related to "insert into select from where out inserted.id"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us