Thank you! Ticket for doc addition: http://www.sqlalchemy.org/trac/ticket/1994
On Dec 6, 6:10 pm, Michael Bayer <mike...@zzzcomputing.com> wrote: > 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 sqlalch...@googlegroups.com. > > To unsubscribe from this group, send email to > > sqlalchemy+unsubscr...@googlegroups.com. > > For more options, visit this group > > athttp://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 sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
