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 vote190 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
1 vote199 views1 answer
How to get the date diff on once field in sql server
SQL
123 votes285 views5 answers
Sql where contains
SQL
0 vote344 views1 answer
How to connect .sql data set to powerbi
SQL
0 vote186 views1 answer
Into operator in sql
SQL
3 votes185 views2 answers
Find string in stored procedure sql server
SQL
4 votes160 views3 answers
Order by value mysql
SQL
0 vote169 views1 answer
Mysql search multiple tables
SQL
0 vote165 views1 answer
Raven ql select count
SQL
17 votes170 views6 answers
Mysql import sql file
SQL