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

4 votes266 views1 answer
Sql group by year
SQL
0 vote274 views1 answer
Install sql server in ubuntu 20.04
SQL
1 vote286 views1 answer
Sql server read uncommitted
SQL
0 vote277 views1 answer
Oracle temporary table
SQL
1 vote272 views1 answer
Sql avg group by
SQL
0 vote268 views1 answer
Multiple tricky query in sql server
SQL
0 vote305 views2 answers
Coursera spark sql max count
SQL
2 votes273 views2 answers
How to DROP a table in mysql
SQL
0 vote285 views1 answer
Recently updated stored procedure in sql server
SQL
2 votes256 views1 answer
Insert from table tsql
SQL