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 vote241 views1 answer
What is common table expression in sql
SQL
0 vote229 views2 answers
Postgres having
SQL
0 vote229 views1 answer
Split first name and last name in sql
SQL
1 vote208 views1 answer
Oracle turn off constraint
SQL
0 vote207 views1 answer
Sqlalchemy get ids
SQL
0 vote320 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
25 votes234 views4 answers
Metadata
SQL
6 votes252 views2 answers
How to get yesterday date in mysql
SQL
1 vote207 views1 answer
Write a query to create an empty table from an existing table?
SQL
15 votes216 views6 answers
Laravel db transaction
SQL