Rollback in Sql query window

• jollyguy4all

  SSC Veteran

  Points: 270

  More actions

  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

• fromnaija

  SSCrazy

  Points: 2876

  More actions

  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