• Thanks cfradenburg, Hugo & GilaMonster.

    I will take the TSQL part, Changes made to Table variables and Scalar variables will not be affected by Rollback. As well as Identity value will not be re-seeded.

    --
    Dineshbabu
    Desire to learn new things..