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 vote312 views1 answer
Oracle NLS_CHARACTERSET
SQL
21 votes291 views4 answers
Add column mssql
SQL
8 votes306 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote331 views1 answer
Wordpress make wp user in db
SQL
0 vote296 views1 answer
Intellij idea add mysql connector
SQL
0 vote279 views1 answer
Oracle job class
SQL
1 vote298 views3 answers
How to filter repeated same result using sql query
SQL
0 vote294 views1 answer
Why we have to set the password for my sql server
SQL
0 vote320 views1 answer
How to pass list as parameter in SQL query
SQL
2 votes296 views1 answer
Sql update \
SQL