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 vote196 views1 answer
Plpgsql raise notice
SQL
0 vote191 views1 answer
Bigquery declare
SQL
0 vote190 views1 answer
Différence entre deux dates sql oracle
SQL
0 vote198 views1 answer
Ksql quickstart docker
SQL
5 votes214 views1 answer
Oracle asynchronous query
SQL
2 votes199 views1 answer
No data found oracle
SQL
0 vote155 views1 answer
Como leer datos de mysql esp32
SQL
1 vote197 views1 answer
Operator does not exist: integer = text
SQL
0 vote203 views1 answer
Exectuer myssql .sql
SQL
-2 votes197 views1 answer
Remove root password mysql
SQL