Returns the most recently assigned value for an identity column. The result is a decimal.
SELECT IDENTITY_VAL_LOCAL(EMP_NO) FROM CORPDATA.EMPLOYEE