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

4 votes154 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote181 views1 answer
Uncheck constraints and delete from table
SQL
0 vote179 views1 answer
Python dictionary to sql update
SQL
6 votes163 views4 answers
How to remove unique key in mysql
SQL
0 vote220 views1 answer
Compare two tables to find unmatched records
SQL
2 votes202 views2 answers
Mysql write into table
SQL
-1 vote175 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote163 views1 answer
How to export only procedures mysql
SQL
0 vote165 views1 answer
We are intrested to work with your organization
SQL
0 vote173 views1 answer
Get rows from 1 table with other table empty mysql
SQL