Loading
Topic
IdentCurrent
3 posts about IdentCurrent by 3 contributors.
Know IdentCurrent? Share what you know with developers who are learning it.
+ Follow IdentCurrentBe the first to follow this
- Articles
- 3
- Contributors
- 3
Articles about IdentCurrent
- Article · SQL
Comparing Scope_identity (), @@identity and Ident_current
This article will show the differences among scope_identity (), @@identity and ident_current.
- Article · SQL
Difference Among @@IDENTITY, SCOPE_IDENTITY() And IDENT_CURRENT()
In this article, I am explaining how to get the last inserted identity value of an auto-increment column of database tables using SQL Server variable (@@IDENITY) and functions (SCOPE_IDENTITY() and IDENT_CURRENT()). Both @@IDENTITY and SCOPE_IDENTITY() return the last identity value that is produced in a single session; in other words, a connection while IDENT_CURRENT() returns the last identity value according to the table for any session.
- Article · SQL
@@ Identity Vs ScopeIdentity Vs Ident_Current in SQL
This article explains @@Identity, Scope_Identity() & Ident_Current('Table_Name') in SQL.
