Remember Identity
If the table has an Identity column whose value will be needed by a single-row
inserting program, select this option.
Then, when a single row is inserted into the table, the system stores SCOPE_IDENTITY() in a process variable named SESSION_IDENTITY(table_name), if it is already defined.