SQL – Inserting a row and returning primary key

by

For MS SQL Server:

SCOPE_IDENTITY() will return you the last generated identity value within your current scope:

SELECT SCOPE_IDENTITY() AS NewID

More Related Contents:

  1. Is there AUTO INCREMENT in SQLite?
  2. Select first row in each GROUP BY group?
  3. SQLite – UPSERT *not* INSERT or REPLACE
  4. Auto Increment after delete in MySQL
  5. How can I list the tables in a SQLite database file that was opened with ATTACH?
  6. Update table values from another table with the same user name
  7. SQL Select between dates
  8. How to pivot in SQLite or i.e. select in wide format a table stored in long format?
  9. Foreign key referring to primary keys across multiple tables?
  10. How can I define a composite primary key in SQL?
  11. Exporting data In SQL Server as INSERT INTO
  12. SQLite – ORDER BY RAND()
  13. How can I insert values into a table, using a subquery with more than one result?
  14. Select random row(s) in SQLite
  15. INSERT rows into multiple tables in a single query, selecting from an involved table
  16. sqlite alter table add MULTIPLE columns in a single statement
  17. Drop all tables command
  18. SQL speed up performance of insert?
  19. SQL Server: Cannot insert an explicit value into a timestamp column
  20. SQL Server 2008 – Help writing simple INSERT Trigger
  21. How to create timestamp column with default value ‘now’?
  22. String concatenation does not work in SQLite
  23. Unfindable SQLite Syntax Error
  24. SQLite3 UNIQUE constraint failed error
  25. Does SQLite3 have prepared statements in Node.js?
  26. How to select the first N rows of each group?
  27. adding primary key to sql view
  28. Retrieve Oracle last inserted IDENTITY
  29. How to bulk insert only new rows in PostreSQL
  30. SQL Populate table with random data

Leave a Comment