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

22 votes400 views1 answer
Mysql workbench
SQL
0 vote276 views1 answer
Oracle sysdba connect as another user
SQL
0 vote312 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
2 votes315 views1 answer
Sql alchemy or
SQL
0 vote316 views1 answer
How to save data in database in mysql node
SQL
33 votes389 views6 answers
Sql delete
SQL
0 vote334 views1 answer
Template MySQL Zabbix agent
SQL
0 vote355 views1 answer
MySQL update with subquery
SQL
1 vote352 views1 answer
Liquibase alter column type / length
SQL
0 vote303 views1 answer
Selects all the columns from the sailors table
SQL