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 vote143 views2 answers
Mysql update table from another table
SQL
18 votes137 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote133 views4 answers
Database stuck at restoring state
SQL
36 votes124 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote139 views1 answer
Get db connection detail from sql developer profile
SQL
1 vote133 views1 answer
Mysql get domain from url
SQL
0 vote150 views2 answers
Sql stored procedure for access frontend
SQL
4 votes126 views3 answers
Sql drop database if exists
SQL
0 vote153 views1 answer
Get create sql of hibernqte entity
SQL
3 votes132 views2 answers
Sql server current date without time
SQL