ASA SQL Reference
  SQL Functions
    Alphabetical list of functions

IDENTITY function [Miscellaneous]

Function 

Generates integer values, starting at 1, for each successive row in a query. Its implementation is identical to that of the NUMBER function.

Syntax 

IDENTITY ( expression )

Parameters 

expression    An expression. The expression is parsed, but is ignored during the execution of the function.

Usage 

For a description of how to use the IDENTITY function, see the NUMBER function [Miscellaneous].

Standards and compatibility 

• SQL/92    Transact-SQL extension.

• SQL/99    Transact-SQL extension.

• Sybase    Offers similar behavior to that of Adaptive Server Enterprise.

See also 

NUMBER function [Miscellaneous]

Example 

The following statement returns a sequentially-numbered list of employees.

SELECT IDENTITY( 10 ), emp_lname FROM employee