Transaction Trio

Question

Post reply

Transaction Trio

Jeff.MSSqlSage

Say Hey Kid

Points: 709
More actions
August 24, 2013 at 4:15 pm

#298081

Comments posted to this topic are about the item Transaction Trio
August 26, 2013 at 1:11 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 27 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Very nice question for a Monday (although I'm already answering this on Sunday evening :-D).

If you forget about this behaviour of table variables in production code...

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

james.of.rivendell SSC-Addicted Points: 425 More actions · Answer 2

james.of.rivendell

SSC-Addicted

Points: 425

August 25, 2013 at 8:16 pm

#1644777

I didn't know this actually. Great question.

kapil_kk SSC-Insane Points: 21316 More actions · Answer 3

Good question to start Monday morning 🙂

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

PRAMANA.DBA SSCertifiable Points: 5507 More actions · Answer 4

PRAMANA.DBA

SSCertifiable

Points: 5507

August 25, 2013 at 11:22 pm

#1644787

Nice question to start Monday

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 5

Good back to basic question. Thanks 🙂

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

ParulPrabu SSCrazy Points: 2271 More actions · Answer 6

ParulPrabu

SSCrazy

Points: 2271

August 26, 2013 at 1:05 am

#1644795

Nice Question :w00t:

manik_anu SSCrazy Points: 2377 More actions · Answer 7

I faced this problem my starting level that while using table variable we cannot rollback.

nice question.

Manik
You cannot get to the top by sitting on your bottom.

Hany Helmy SSChampion Points: 13921 More actions · Answer 8

Good to know some new info; 😉

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Umer Akram SSC-Insane Points: 22209 More actions · Answer 9

Umer Akram

SSC-Insane

Points: 22209

August 26, 2013 at 3:56 am

#1644828

Excellent question ... keep it up!!! 🙂

Divine Flame SSCoach Points: 15943 More actions · Answer 10

Thanks for the question & for pointing us towards the great explanation available on the SE (by Martin Smith).

Sujeet Singh

Jeff.MSSqlSage Say Hey Kid Points: 709 More actions · Answer 11

Koen Verbeeck (8/25/2013)
Very nice question for a Monday (although I'm already answering this on Sunday evening :-D).
If you forget about this behaviour of table variables in production code...

... what ? what happens ? Everything will be ok, right !? Tell me everything will be ok !

TomThomson SSC Guru Points: 104773 More actions · Answer 12

Good question, and really terrific reference. That page should debunk many widely believed myths and isn't propagating any, which is quite unusual for a page that talks about the differences between temp tables and table variables.

Tom

logitestus SSCrazy Points: 2928 More actions · Answer 13

Note to self: do not try to answer SQL questions (no matter how simple) before 1st cup of coffee is consumed. In hindsight, I actually had the right answer but forgot completely (or fell asleep) when I went to click the answer.