@@IDENTITY (SQL Server Compact Edition)

Returns the last-inserted identity value.

Syntax

SELECT @@IDENTITY
or
SELECT @@IDENTITY AS 'TEMPNAME'

Return Value

numeric

Change History

Release

History

5 December 2005

Term

Definition

Changed content

  • Updated syntax