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

12 votes203 views4 answers
Mysql get date difference in hours
SQL
6 votes237 views2 answers
Oracle compile trigger
SQL
10 votes211 views2 answers
Mysql drop database if exists
SQL
5 votes203 views2 answers
Mysql import gzip db
SQL
0 vote201 views1 answer
Search mysql database for column
SQL
0 vote216 views1 answer
Shrink database file in sql server
SQL
0 vote199 views1 answer
How to add unique key constraint in mysql
SQL
1 vote176 views1 answer
Stored procedure return value
SQL
0 vote181 views1 answer
Ffeathers express mysql application users login
SQL
0 vote184 views1 answer
How to see the query of a view in mysql
SQL