SQL Server 2005 query based execution

• bhramprasad

  Grasshopper

  Points: 10

  More actions

  July 15, 2010 at 4:43 pm

  #226834

  I have 2 queries. 1st query updates some table and runs 2nd query. If for some reason, 2nd query fails, 1st query updates should not happen. How to accomplish this. Please Help. Regards.

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  July 15, 2010 at 5:58 pm

  #1193838

  Duplicate posting see http://www.sqlservercentral.com/Forums/Topic953545-1292-1.aspx

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]