title: Truncate Table Within Transaction
body: <p>Can the SQL "truncate table" command be used within a transaction?  I am creating an app and my table has a ton of records.  I want to delete all the records, but if the app fails I was to rollback my transaction.  Deleting each record takes a very long time.  I'm wondering if I use truncate table, can I still rollback the transaction and get my data back in the event of a failure.  I realize that truncate table doesn't write each delete to the transaction log, but I'm wondering if it writes the page deallocation to the log so that rollback works.  </p>