SQL Reference Guide

LAST_IDENT function (extension)

Syntax

LAST_IDENT ( )

Description

The scalar function LAST_IDENT() returns the last inserted IDENTITY value for the session.

Example

SELECT LAST_IDENT();

Notes

• The result is of type NUMERIC(32,0)