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 vote206 views1 answer
Sql delete caracter list
SQL
0 vote223 views1 answer
Select nth row in mysql
SQL
0 vote205 views1 answer
Incorrect string value: mysql
SQL
0 vote247 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote207 views1 answer
Fast sql column count
SQL
0 vote200 views1 answer
Sql change date format
SQL
0 vote206 views1 answer
Test the postgresql db connection
SQL
1 vote211 views1 answer
Sql upsert
SQL
42 votes254 views6 answers
Rename table sql server
SQL
5 votes214 views4 answers
Upload database mysql command line
SQL