scope_identity vs ident_current

by

In that case you need to write the table name, what happens if you decide to change the table name? You then also must not forget to update your code to reflect that. I always use SCOPE_IDENTITY unless I need the ID from the insert that happens in a trigger then I will use @@IDENTITY

Also the bigger difference is that IDENT_CURRENT will give you the identity from another process that did the insert (in other words last generated identity value from any user)
so if you do an insert and then someone does an insert before you do a SELECT IDENT_CURRENT you will get that other person’s identity value

See also 6 Different Ways To Get The Current Identity Value which has some code explaining what happens when you put triggers on the table

More Related Contents:

  1. How can I do an UPDATE statement with JOIN in SQL Server?
  2. Not equal != operator on NULL
  3. SET NOCOUNT ON usage
  4. How can I get column names from a table in SQL Server?
  5. How can I select the first day of a month in SQL?
  6. Subquery using Exists 1 or Exists *
  7. Truncate (not round) decimal places in SQL Server
  8. Most efficient T-SQL way to pad a varchar on the left to a certain length?
  9. Is it possible to specify condition in Count()?
  10. Update records in table from CTE
  11. Dynamic Pivot Columns in SQL Server
  12. Is it possible to select sql server data using column ordinal position
  13. Selecting N rows in SQL Server
  14. how can I Update top 100 records in sql server
  15. How can I INSERT data into two tables simultaneously in SQL Server?
  16. SQL “select where not in subquery” returns no results
  17. How can a LEFT OUTER JOIN return more records than exist in the left table?
  18. Count Number of Consecutive Occurrence of values in Table
  19. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  20. Dynamic SQL to generate column names?
  21. Pivot data in T-SQL
  22. Column name or number of supplied values does not match table definition
  23. How to find consecutive rows based on the value of a column?
  24. T-SQL – Aliasing using “=” versus “as” [closed]
  25. Which SQL query is faster? Filter on Join criteria or Where clause?
  26. SQL Query – Concatenating Results into One String [duplicate]
  27. T-SQL Skip Take Stored Procedure
  28. COALESCE Function in TSQL
  29. Convert bigint to datetime
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment