Using the SELECT INTO or BULK INSERT will bypass transactions if you have the specific database configured for it (under options for Select Into /Bulk Copy Option). And yes, the SELECT INTO is also another way to bypass the transaction log into a table.
Other than that, the best way to generally bypass the problem is to make sure and use temporary tables for any intermediate table writes. When you drop the temp tables, the associated transactions will also be dropped.