Home Forums Article Discussions Article Discussions by Author Discuss content posted by Gobikannan Ponmalai TRUNCATE in TRANSACTION RE: TRUNCATE in TRANSACTION

  • January 4, 2011 at 5:44 am

    #1268878

    Hugo Kornelis (1/4/2011)

    I replied wrong - I saw the rollback after the truncate, assumed the question intended to test my understanding that a truncate can be rolled back, and then replied. I had not seen the missing ALL after the UNION operators, nor noticed the duplicate row.

    Whew! If I got it wrong for the same reason Hugo did, then I must be doing okay. 😀

    ron

    -----
    a haiku...

    NULL is not zero
    NULL is not an empty string
    NULL is the unknown