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 vote104 views2 answers
Mysql update table from another table
SQL
0 vote121 views1 answer
Find invalid datetime field
SQL
0 vote120 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote117 views1 answer
How to check event scheduler status mysql
SQL
2 votes119 views1 answer
Sql string_agg
SQL
0 vote123 views1 answer
Second Step in installing SQL workbench
SQL
10 votes107 views1 answer
Create table oracle
SQL
0 vote124 views1 answer
How to display value of variable in mysql
SQL
0 vote138 views1 answer
How to find date from date table in sql
SQL
3 votes126 views2 answers
Get current year sql
SQL