Error control and transaction handling (please correct me)

• Dean Jones-454305

  SSCarpal Tunnel

  Points: 4804

  More actions

  July 16, 2009 at 5:56 am

  #208195

  Hi Everyone

  I have a code here which for some reason branches to the GOTO statement, I think there is something wrong within the code itself, can someone help me re-write it properly, I want to have transactional handling and error control at thesame time.

  Also, transactional handling tends to fail with an open transaction if the table isn't present, is this a normal behaviour ?

  Create procedure SpTest

  as

  Begin

  BEGIN TRAN

  Select top 10 name into #temp from sysobjects

  IF @@ERROR <> 0

  GOTO ErrorControl

  COMMIT

  ErrorControl:

  Print 'There was an error'

  ROLLBACK

  End

• Ian Scarlett

  SSC-Insane

  Points: 23197

  More actions

  July 16, 2009 at 6:08 am

  #1025551

  The chances are it's not branching to the GOTO, but dropping into it. You need to put a RETURN immediately after the COMMIT.