Post reply

Rollback in Sql query window

  • August 20, 2003 at 6:09 am

    #176316

    Hi,

    I use ms sql query analyzer/window to run my queries and do bulk updates / inserts/ deletes as everyone might do.

    Sometimes while i am updating a bunch of records there are times when i by mistake write a wrong condition and all records get updated with a particular value. Is there a way to roll back such statements?

    I have to deal with a users database of more than 100K and in such situations when say i am udation job titles of people and if such and error occurs it can spell disaster.

    Please advise and oblige.

    Thanks and regards

    Hitendra

  • August 20, 2003 at 6:58 am

    #470587

    You could put your query into a transaction but for the situation you describe where you write a wrong condition, you may be out of luck once your transaction is committed.


    Joseph

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply