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

20 votes320 views5 answers
Reset auto increment mysql
SQL
0 vote329 views1 answer
Oracle cpu metric
SQL
0 vote303 views1 answer
Sql query for displaying age from oldest to youngest
SQL
0 vote330 views1 answer
Split string by comma in sql server
SQL
0 vote337 views1 answer
Check user sql password from command line
SQL
0 vote318 views1 answer
Sql count total by foreign key
SQL
0 vote336 views1 answer
View psql output in horizontal scrolling
SQL
0 vote300 views1 answer
Mysql command prompt date insert format
SQL
2 votes318 views1 answer
Add new column not null sql server
SQL
5 votes308 views2 answers
Oracle show procedures
SQL