last identity inserted. SELECT IDENTITY(); Triggers If triggers are defined on the table on which the statement operates, those triggers are evaluated in the context of the operation. triggers allow the modification of the values that shall be inserted into the table. triggers cannot modify the data anymore, but can be used to initiate actions on other tables, for example, to implement auditing mechanism. References External links Oracle SQL INSERT statement (Oracle Database SQL Language Reference, 11g Release 2 (11.2) on oracle.com) Microsoft Access Append Query Examples and SQL INSERT Query Syntax MySQL statement (MySQL 5.5 Reference Manual) SQL keywords Articles with example SQL code