Answers for "insert into sql 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

id increment ms sql server

CREATE TABLE Persons (
    Personid int IDENTITY(1,1) PRIMARY KEY,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int
);

Posted by: Guest on April-29-2020

Code answers related to "insert into sql id"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "insert into sql id"

Code answers related to "insert into sql id"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "insert into sql id"

Code answers related to "insert into sql id"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us