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

Similar codes

11 votes330 views2 answers
Oracle all source
SQL
13 votes352 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
1 vote376 views1 answer
How to see logical reads in sql server
SQL
0 vote371 views1 answer
Cahnge column name apex oracle
SQL
4 votes325 views2 answers
Mysql show indexes on table
SQL
0 vote347 views1 answer
Postgres populate table from another table
SQL
1 vote286 views1 answer
Into sql
SQL
0 vote369 views1 answer
Gcloud sql instance list
SQL
0 vote331 views1 answer
Mysql query single row
SQL
0 vote334 views1 answer
Mysql count with two joins
SQL