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 vote149 views1 answer
Template MySQL Zabbix agent
SQL
2 votes132 views1 answer
Oracle find constraints referencing a table
SQL
1 vote136 views2 answers
Pl sql case
SQL
0 vote141 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
-1 vote170 views4 answers
Sql view postgresql
SQL
0 vote157 views1 answer
Except in sql
SQL
0 vote139 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
9 votes127 views2 answers
Default number in sql
SQL
2 votes138 views2 answers
Set database timezone mysql
SQL
0 vote131 views1 answer
Can we rollback deleted data in sql
SQL