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 vote260 views2 answers
How to use aggregate functions in sql
SQL
8 votes282 views3 answers
Postgres database sizes
SQL
1 vote245 views1 answer
Sample in sql
SQL
7 votes257 views1 answer
Set sequence value oracle
SQL
7 votes259 views6 answers
Reset identity column in sql server
SQL
0 vote238 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote289 views1 answer
Joomla execute raw sql
SQL
1 vote290 views2 answers
Install sql server management studio ubuntu
SQL
0 vote258 views1 answer
Sql period overlap
SQL
13 votes275 views3 answers
Change data type postgresql
SQL