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

1 vote239 views1 answer
How to unlock table in mysql
SQL
2 votes242 views1 answer
Postgresql transaction
SQL
0 vote228 views1 answer
Porcentaje sql
SQL
0 vote237 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
58 votes386 views4 answers
Mysql drop column
SQL
5 votes231 views1 answer
Oracle sysdate
SQL
2 votes295 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote251 views2 answers
Mysql two column combination unique
SQL
10 votes259 views2 answers
Mysql drop database if exists
SQL
4 votes232 views3 answers
Mysql modify foreign key
SQL