Posted by nicolas.bouchard@gmail.com on 04/24/06 21:43

Just thought about posting the SQL command in the adapter, it will look
something like:

SET IDENTITY_INSERT myTable ON; INSERT INTO myTable (myId, myCol1)
VALUES (@myId, @myCol1); SELECT myId, myCol1 FROM myTable WHERE (myId =
@@IDENTITY); SET IDENTITY_INSERT myTable OFF;

I hope that will help !

• Next in forum: Re: SELECT * FROM "multiple_tables" WHERE "field_(in_those_tables)_have_the_same_paricular_value" ?
• Prev in forum: Cannot insert explicit value for identity...
• Thread view: Re: Cannot insert explicit value for identity...

[Reply to this message]