Resource

IDENT_CURRENT

Shankar M Resources Dec 14, 2012
IDENT_CURRENT column in SQL Server.


IDENT_CURRENT:

  Returns the last identity value generated for a specified table or view. The last identity value generated can be for any session and any scope. 

Syntax:

IDENT_CURRENT( 'table_name' )

Paramters:

table_name

  Is the name of the table whose identity value is returned. table_name is varchar, with no

default.

Return Value:

numeric(38,0)

Returns - NULL on error or if a caller does not have permission to view the object.

The function however differs by its scope and session from @@IDENTITY and SCOPE_IDENTITY

IDENT_CURRENT returns the last identity value generated for a specific

table in any session and any scope.

@@IDENTITY returns the last identity value generated for any table in

the current session, across all scopes.

SCOPE_IDENTITY returns the last identity value generated for any table

in the current session and the current scope.

When the IDENT_CURRENT value is NULL (because the table has never contained rows or has been truncated), the IDENT_CURRENT function returns the seed value.

 References :  MSDN

 

 

COMMENT USING

PREMIUM SPONSORS

Hire Mobile & Web Developer on demand. 100% satisfaction. Try for 1 week or Money Back. Local and remote developers available all over USA.

TOP RESOURCES

MOST LIKED RESOURCES