Re: [sqlalchemy] MSSQL: OUTPUT clause is throwing an error on a table with an INSERT trigger

2010-12-06 Thread Michael Bayer
specify implicit_returning = False as part of the Table arguments. Should probably add a note to the MSSQL docs on this. On Dec 6, 2010, at 5:41 PM, Randy Syring wrote: > I am executing a bulk insert which is resulting in SQL like: > > INSERT INTO equipment (equipment_type_id, number, mark,

[sqlalchemy] MSSQL: OUTPUT clause is throwing an error on a table with an INSERT trigger

2010-12-06 Thread Randy Syring
I am executing a bulk insert which is resulting in SQL like: INSERT INTO equipment (equipment_type_id, number, mark, inactive) OUTPUT inserted.id VALUES (?, ?, ?, ?)' (6, u'1', None, 0) But I have a trigger on equipment that does some validity checking. When executing, I get an exception whic