Try/Catch and Finally Block in sql server

• sanjeev40084

  SSC-Addicted

  Points: 449

  More actions

  July 6, 2009 at 1:34 pm

  #202030

  Does Sql Server supports 'Finally Block' in query?

  Begin Try

  End Try

  Begin Catch

  End Catch

  Begin Finally?

  ?

  End Finally?

  P.S = I am trying to use finally so that i can drop my temp. table.

• Jack Corbett

  SSC Guru

  Points: 184393

  More actions

  July 6, 2009 at 1:41 pm

  #1020615

  Nope, no FINALLY in SQL Server at this time. http://technet.microsoft.com/en-us/library/ms175976.aspx

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• sanjeev40084

  SSC-Addicted

  Points: 449

  More actions

  July 7, 2009 at 8:02 am

  #1021072

  thanks