Sybase Adaptive Server Anywhere

To Next Page

To Previous Page

Variables

258

When an insert causes referential integrity actions or fires a trigger,

@@identity

behaves like a stack. For example, if an insert into a table

(with an identity or autoincrement column) fires a trigger that inserts a row

into table

(also with an identity or autoincrement column), then the value

returned to the application or procedure which carried out the insert is the

value inserted into

. Within the trigger,

@@identity

has the

value

before the insert into

and the

value after. The trigger can copy the

values to local variables if it needs to access both.

@@identity and

triggers

Sybase Adaptive Server Anywhere - Page 276