**Syntax:**

The IDENTITY_VAL_LOCAL function is a non-deterministic function -that returns the most recently assigned value for an identity column, where -the assignment occurred as a result of a single row INSERT statement using -a VALUES clause.

The IDENTITY_VAL_LOCAL function has no input parameters. The result is a DECIMAL (31,0), regardless of the actual data type of the corresponding identity column.

The value returned by the IDENTITY_VAL_LOCAL function is the value
-assigned to the identity column of the table identified in the most recent
-single row INSERT statement. The INSERT statement must contain a VALUES clause
-on a table containing an identity column. The assigned value is an identity
-value generated by

The value returned by the IDENTITY_VAL_LOCAL function, for a connection,
+is the value assigned to the identity column of the table identified in the
+most recent single row INSERT statement. The INSERT statement must contain
+a VALUES clause on a table containing an identity column. The assigned value
+is an identity value generated by

The result of the function is not affected by the following: @@ -44,7 +43,10 @@ an identity column

**Examples:**