IMPLICIT_TRANSACTIONS & BEGIN TRAN (second)

• Carlo Romagnano

  SSC-Insane

  Points: 22745

  More actions

  January 14, 2015 at 10:26 pm

  #300396

  Comments posted to this topic are about the item IMPLICIT_TRANSACTIONS & BEGIN TRAN (second)

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  January 15, 2015 at 1:31 am

  #1770337

  Interesting question, thanks.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• January 15, 2015 at 2:19 am

  This was removed by the editor as SPAM

• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  January 15, 2015 at 5:15 am

  #1770414

  An interesting one to be sure. Thanks.

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions

• Michael_Garrison

  Hall of Fame

  Points: 3110

  More actions

  January 15, 2015 at 5:34 am

  #1770420

  Interesting question - learned something.

• Raghavendra Mudugal

  SSChampion

  Points: 10658

  More actions

  January 15, 2015 at 5:43 am

  #1770423

  Thank you for the post, Carlo, good one.

  (I tried this scenario in the previous qtod on the same subject and was sure..:cool:)

  ww; Raghu
  --
  The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  January 15, 2015 at 7:32 am

  #1770455

  Thanks for the question.

• stephen.long.1

  SSCrazy

  Points: 2591

  More actions

  January 15, 2015 at 8:02 am

  #1770468

  Nice question, Carlo. Thanks!

• RK Mandava

  SSCarpal Tunnel

  Points: 4153

  More actions

  January 15, 2015 at 8:16 am

  #1770477

  Nice Question

• DonlSimpson

  SSCertifiable

  Points: 7043

  More actions

  January 15, 2015 at 9:36 am

  #1770498

  Not sure what the purpose is for the "SET IMPLICIT_TRANSACTIONS OFF" at the end of the script.

  Don Simpson
  

  ---

  
  I'm not sure about Heisenberg.

• Dana Medley

  SSCertifiable

  Points: 6764

  More actions

  January 15, 2015 at 9:58 am

  #1770509

  Thanks for the question. I learned something today.

  ---

  
  Everything is awesome!

• webrunner

  SSC-Dedicated

  Points: 31973

  More actions

  January 15, 2015 at 11:36 am

  #1770528

  Thanks for the interesting question.

  - webrunner

  -------------------
  A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
  Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

• TomThomson

  SSC Guru

  Points: 104773

  More actions

  January 15, 2015 at 4:31 pm

  #1770594

  Nice question.

  At first I thought it would have been better to make this number 1 in the sequence, and make number 1 number 2, but seeing the numbers going for options 3 and 4 I guess this way round is quite educational too.

  Tom