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

0 vote128 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
2 votes116 views1 answer
Mysql find tables with name
SQL
0 vote174 views1 answer
Parent and child link in mysql
SQL
0 vote154 views1 answer
Sql order by number not ordered
SQL
14 votes130 views2 answers
Oracle limit rows
SQL
25 votes146 views1 answer
How to update an attribute in MySQL
SQL
0 vote112 views3 answers
Sql count condition
SQL
8 votes121 views2 answers
Select table column name in sql
SQL
0 vote120 views1 answer
Find invalid datetime field
SQL
2 votes116 views1 answer
Mysql increment value by 1 in update
SQL