Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    83

    Unhappy Unanswered: failure during updation

    In SQL SERVER if there is failure during updation of certain rows, what will be the state?

  2. #2
    Join Date
    Jan 2005
    Location
    TempDb
    Posts
    228
    The state will be like New Jersey (specifically, Newark), I think.

    You need to provide more information for someone to accurately define the state, however you can assume that if the Update fails, the rows you attempted to Updated did not get updated.

    Whether or not that's an error depends on your application. If your application isn't handling the 'failed state' (North Dakota?), then you'll be in a state of mess a chusetts, I think.

  3. #3
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    That's a "politically" overloaded stament, but the gutt is right on the money, - the transaction (explicit or implicit, regardless of error handling) will fail and the data will be in "pre-update" state, like what Texas used to be.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  4. #4
    Join Date
    Dec 2004
    Posts
    47
    this was an interesting thread )

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •