I discovered a different method that works beautifully when I put it into the SQL editor directly, but it's not functional when executing through php.
Code:
INSERT INTO table1(some_data)
VALUES ('some notes');
INSERT INTO table2(Pri_ID,other_data)
VALUES (IDENT_CURRENT('table1'),'something else')
Leave a comment: