On 2014-07-02 08:22 AM, Gili wrote:
permission has a single IDENTITY column. I am expecting SCOPE_IDENTITY() to return the inserted ID in the second statement. Any ideas why this is not happening?
Do you have a standalone test case? This is working for me: create table permission(id identity); create table users(version int, permission_id int, foreign key (permission_id) references permission(id)); insert into permission values(); insert into users values (0, scope_identity()); -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
