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, inactive) > OUTPUT inserted.id VALUES (?, ?, ?, ?)' (6, u'11111', None, 0) > > But I have a trigger on equipment that does some validity checking. > When executing, I get an exception which relays the following info > from SQL server: > > DML statement cannot have any enabled triggers if the statement > contains an OUTPUT clause without INTO clause. > > I am not sure what to do about this and would appreciate suggestions/ > discussion. > > Thanks. > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
