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

2 votes184 views2 answers
Mysql search for column name in all tables
SQL
0 vote181 views1 answer
How to display value of variable in mysql
SQL
1 vote196 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
0 vote197 views1 answer
Learnxinyminutes sql
SQL
0 vote198 views1 answer
Insert ip address in mysql
SQL
9 votes172 views4 answers
Mysql show table fields
SQL
39 votes193 views5 answers
Sql drop column
SQL
-1 vote165 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
6 votes191 views2 answers
What is non relational database
SQL
4 votes203 views3 answers
Postgres drop all tables
SQL