Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

Multi-statement execution Expand / Collapse
Author
Message
Posted Tuesday, February 2, 2010 8:25 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, April 30, 2014 11:35 AM
Points: 311, Visits: 284
Comments posted to this topic are about the item Multi-statement execution
Post #858374
Posted Tuesday, February 2, 2010 11:05 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 2:20 PM
Points: 3,966, Visits: 5,207
Nice question

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #858406
Posted Tuesday, February 2, 2010 11:05 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, September 15, 2014 1:13 AM
Points: 1,535, Visits: 2,577
I din't notice the concatenated "delete" statement and I gave wrong answer. Still I don't think it's a good question or at least it's not worth 2 points.
Post #858407
Posted Wednesday, February 3, 2010 12:47 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 9:09 PM
Points: 17,628, Visits: 15,487
I think this is an excellent question. One must read through the script for starters, and catch the subtleties.

Secondly, there is a concatenation lesson to be learned concerning SQL Injection.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #858436
Posted Wednesday, February 3, 2010 1:20 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:19 AM
Points: 2,112, Visits: 5,477
I think that this was a very good question. I certainly learned something from it. I was sure that the answer would be 0 and was surprised that I got it wrong. I’ve also noticed that unlike most times we didn’t get a link to any official site that explains this behavior, which brings me to the question - Is this behavior is documented and by design?

Adi


--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #858446
Posted Wednesday, February 3, 2010 1:26 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 30, 2014 2:51 AM
Points: 2,036, Visits: 369
nice question.. thanks
Post #858448
Posted Wednesday, February 3, 2010 1:58 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, September 15, 2014 1:13 AM
Points: 1,535, Visits: 2,577
Wel, Usualy I answer the question by reading it on the screen itself. I never copy and paste it in query analyzer.Had I copied it in query analyzer and read I would have definetly give right answer. Hence I dint feel it's a good question.
Post #858459
Posted Wednesday, February 3, 2010 2:29 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, July 3, 2012 5:49 AM
Points: 418, Visits: 365
Tricky question, but not good for learning...good for dry run
Post #858470
Posted Wednesday, February 3, 2010 2:32 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 6:13 AM
Points: 20,572, Visits: 9,618
Joy Smith San (2/3/2010)
Wel, Usualy I answer the question by reading it on the screen itself. I never copy and paste it in query analyzer.Had I copied it in query analyzer and read I would have definetly give right answer. Hence I dint feel it's a good question.



So good questions are only the ones you can answer???
Post #858471
Posted Wednesday, February 3, 2010 3:32 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, September 12, 2014 6:43 AM
Points: 1,113, Visits: 3,125
Joy Smith San (2/3/2010)
Wel, Usualy I answer the question by reading it on the screen itself. I never copy and paste it in query analyzer.Had I copied it in query analyzer and read I would have definetly give right answer. Hence I dint feel it's a good question.


I don't understand how your reliance on reading the code in QA to get it right has any bearing on the question being good or not.... How would reading it in QA (I assume you do mean reading and not executing) have caused you to work out a different answer?
Post #858487
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse