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

13 votes196 views2 answers
Sql join
SQL
0 vote192 views1 answer
Select even number id data from table
SQL
0 vote220 views1 answer
Mysql command line top 10
SQL
8 votes195 views1 answer
Script to add datafile to tablespace
SQL
0 vote187 views1 answer
Postgresql get diff between two dates in Months
SQL
0 vote257 views1 answer
Migrations.RunSQL
SQL
6 votes181 views2 answers
Oracle
SQL
0 vote175 views1 answer
Opening xampp mysql in cmd ubuntu
SQL
9 votes218 views1 answer
Identity insert on sql server
SQL
1 vote186 views1 answer
Base nosql
SQL