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 vote97 views1 answer
Dump multiple tables mysql
SQL
0 vote106 views1 answer
MySQL INSERT IGNORE Statement
SQL
0 vote57 views1 answer
How to set field to null in sql
SQL
1 vote101 views1 answer
Restart identity postgresql
SQL
0 vote113 views1 answer
Get last date join sql
SQL
-1 vote108 views3 answers
My sql alter table
SQL
0 vote100 views1 answer
Mysql add comment to column
SQL
1 vote121 views1 answer
Insert value to new table by joining 2 different tables
SQL
1 vote122 views1 answer
Sql list all procedures
SQL
3 votes100 views2 answers
To_char oracle
SQL