SQL Server – Return value after INSERT

by

No need for a separate SELECT…

INSERT INTO table (name)
OUTPUT Inserted.ID
VALUES('bob');

This works for non-IDENTITY columns (such as GUIDs) too

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. sql server 2008 management studio not checking the syntax of my query
  3. Split function equivalent in T-SQL?
  4. Querying data by joining two tables in two database on different servers
  5. Is having an ‘OR’ in an INNER JOIN condition a bad idea?
  6. Where value in column containing comma delimited values
  7. How to find all connected subgraphs of an undirected graph
  8. How to use table variable in a dynamic sql statement?
  9. SQL query to split column data into rows
  10. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  11. Create Trigger to log SQL that affected table?
  12. Transfer data from one database to another database
  13. How to find third or nᵗʰ maximum salary from salary table?
  14. SQL “between” not inclusive
  15. Can I set ignore_dup_key on for a primary key?
  16. Selecting first row per group
  17. Using PIVOT in SQL Server 2008
  18. sql group by only rows which are in sequence
  19. Function in SQL Server 2008 similar to GREATEST in mysql?
  20. How to retrieve field names from temporary table (SQL Server 2008)
  21. When using GETDATE() in many places, is it better to use a variable?
  22. SQL Server SELECT INTO @variable?
  23. How do I change db schema to dbo
  24. How to subtract 30 days from the current date using SQL Server
  25. Count records for every month in a year
  26. SQL Server: +(unary) operator on non-numeric Strings
  27. Use one CTE many times
  28. How to Select Every Row Where Column Value is NOT Distinct
  29. How to do a case sensitive GROUP BY?
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment