• Conficker - Friday, February 9, 2018 4:14 AM

    Agree with the DELETE statement, would suggest to use BEGIN TRAN to be on a safe side and then COMMIT

    Doesn't make much difference for a single statement.  If you're doing this in a lot of batches then you don't want to be doing an explicit COMMIT after each one.

    John