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

1 vote195 views1 answer
How to select multiple columns from different tables in mysql
SQL
0 vote196 views1 answer
Sql select column names starting with
SQL
0 vote184 views1 answer
Inner joint
SQL
0 vote217 views1 answer
How to check oracle index table
SQL
4 votes154 views1 answer
Oracle sleep
SQL
0 vote214 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
4 votes216 views1 answer
Search column by name mysql
SQL
0 vote278 views1 answer
Install ms sql server management studio
SQL
0 vote211 views1 answer
Mysql select all where count more than"
SQL
10 votes365 views4 answers
Mysql if else
SQL