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 vote141 views1 answer
Sometimes i cant edit sql developer
SQL
1 vote127 views3 answers
How to filter repeated same result using sql query
SQL
13 votes132 views6 answers
Restart postgresql
SQL
0 vote148 views2 answers
SQL FROM
SQL
0 vote131 views1 answer
How to check which sp is running in sql server
SQL
-1 vote153 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
11 votes259 views2 answers
Import mysql dump command line windows
SQL
9 votes168 views3 answers
Date format in sql
SQL
0 vote138 views1 answer
Split string by comma in sql server
SQL
0 vote119 views1 answer
Ms sql unique
SQL