Commit vs Commit Transaction

• clayton-723571

  SSC Veteran

  Points: 290

  More actions

  February 8, 2012 at 4:17 am

  #256382

  Hi

  im looking at a piece of code that randomly fails

  it goes along the line of something like

  While Something

  BEGIN

  Begin Trasnaction

  Insert Into Table

  Commit

  END

  Firstly i have added the rollback on the @@ERROR check , but im wodering if there is any differance between calling Commit and Commit Transction

  Regards

  Clayton.

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  February 8, 2012 at 4:22 am

  #1444408

  No. The word TRANSACTION is optional after COMMIT or ROLLBACK.

  Don't add @@error, add a try-catch construct.

  Gail Shaw
  Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
  SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass

• clayton-723571

  SSC Veteran

  Points: 290

  More actions

  February 8, 2012 at 4:30 am

  #1444414

  Thanks alot