# Multi-statement transactions with ActiveRecord

**URL:** <https://www.ruby-forum.com/t/multi-statement-transactions-with-activerecord/107941>\
**Category:** Rails\
**Created:** [June 27, 2007, 6:50pm UTC](https://www.ruby-forum.com/t/multi-statement-transactions-with-activerecord/107941 "2007-06-27T18:50:40Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![weyus](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/7ab992/32.png) [@weyus](https://www.ruby-forum.com/u/weyus)\
**Post date:** [June 27, 2007, 6:50pm UTC](https://www.ruby-forum.com/t/multi-statement-transactions-with-activerecord/107941/1 "2007-06-27T18:50:40Z")

</div>

All,

Using Rails 1.1.6  
AR against MS SQL Server (ODBC mode).

I need to do some fancy bulk inserting of data, which I need to ensure  
is within a transaction. But as I think about it, it isn’t clear to me  
whether what I want to do will work within standard AR.

Can I do something like this:

MyClass.transaction do  
MyClass.connection.execute(“arbitrary SQL”)

end