RE: Auto-generated keys using Sybase

[Engel, Gregory A]

I'm using Sybase here and it is the same as MS SQL Server
I do this inside the insert.

        <selectKey resultClass="long" keyProperty="id">
                SELECT @@identity as id
        </selectKey>    

Straight from the help files....