Differences between several functions in the ID column

-- Differences between several functions of the ID column

 

-- @ Difference between identity and scope_identity and ident_current

 

@ Identity -- Obtain the last inserted identity value for all scopes of the current session.

Scope_identity () -- Obtain the last inserted identity value of the current scope of the current session.

Ident_current () -- Obtain the last inserted identity value of the specified table, regardless of the session and scope.

 

-- A session is a user connection.

-- A scope is a module-stored procedure, trigger, function, or batch processing.

========================================================== =

 

-- Several functions related to the identifier.

 

Select ident_current ('table name') -- identifies the current value

Select ident_incr ('table name') -- id Increment

Select ident_seed ('table name') -- identifies a seed