Yes, you can truncate a table within a transaction!
I sometimes wonder how some people can claim certain idea’s as the truth, without proper proof. In this case, I heared somebody say "Of course you can’t truncate a table within a transaction, because a truncate is not logged. You will have to use a delete statement.". Well, that’s just wrong, and Paul Randall provides the proof:
Categories: SQL Server
Comments