thanx julian

i know we rollback transactions. thats why i've mentioned "update statement".

and thats exactly what i want . do u have any answer