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 «««1234»»

T-SQL Syntax Expand / Collapse
Author
Message
Posted Friday, August 17, 2012 10:05 AM
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: Friday, August 29, 2014 8:18 AM
Points: 3,909, Visits: 3,636
I had no idea what the correct answer was and still don't.
Post #1346644
Posted Friday, August 17, 2012 11:33 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 12:32 PM
Points: 1,316, Visits: 1,686
Cliff Jones (8/17/2012)
I had no idea what the correct answer was and still don't.


There is no correct answer. Several terms in the question were vague enough to ensure that. It's a great concept to think about and discuss, but I don't think a QotD served well as the mechanism to introduce it.
Post #1346687
Posted Friday, August 17, 2012 2:15 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, February 12, 2014 10:49 PM
Points: 20, Visits: 263
Hugo - I appreciate your comments, and probably agree with most of them.

If this generated some thinking, some head scratching, some friendly debate, and even a little education, I think the QoD goal has been met, even if not delivered quite perfectly.

And maybe it helps us remember that this is a pretty complex product we program & support. And that we are not deficient at our job if we do not have every detail memorized.

But Yes, I am the person that occasionally will "read BOL entirely" just for curiosity, and to maybe discover something new and interesting and maybe even useful! [And yes, I also am the rare person who reads farther than the first page of Google results.]



Post #1346746
Posted Friday, August 17, 2012 7:06 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 8:26 AM
Points: 1,803, Visits: 2,168
Hugo Kornelis (8/17/2012)
I appreciate the amount of research that went into this question and I think it has a good educational value, but I don't think a QotD is the right form for this education - at least not a QotD in this specific form.


Got to this late today. So thanks to Hugo for saving me having to respond with that thought. However, my response would not have been so detailed or well written. I appreciate the effort of OP, but looked at the question after a long day and thought, "Who cares?" But that says more about me and my day than the question.


Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1346792
Posted Saturday, August 18, 2012 3:43 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, August 29, 2014 10:36 PM
Points: 808, Visits: 1,575
Cliff Jones (8/17/2012)
I had no idea what the correct answer was and still don't.

+1




One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important.
Bertrand Russell
Post #1346887
Posted Monday, August 20, 2012 3:02 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 29, 2014 10:20 AM
Points: 1,740, Visits: 6,366
I got it right - but my list of possibilities was different from the questioner's
Post #1347035
Posted Monday, August 20, 2012 3:36 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 12:09 AM
Points: 302, Visits: 178
Interesting question, and my answer were pure guesswork. I would argue with the first kind, as arguments to function calls or procedures. Although they can be varied, I don't regard an input argument to be a variable. Output variables are a special kind, but ARE assignments to variables outside the SP.

But I will side with Hugo in regarding this as a question with no clearly defined answer.

Thanks for a QoT that sparked a good discussion.
Post #1347044
Posted Monday, August 20, 2012 10:05 AM


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: Friday, August 29, 2014 10:23 AM
Points: 3,299, Visits: 1,978
Wow, that was a tough one. I think I could have researched all day and still missed this one. At least it started some good discussion.
Post #1347306
Posted Tuesday, August 21, 2012 10:21 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, August 22, 2014 8:50 AM
Points: 4,425, Visits: 3,417
GPO (8/18/2012)
Cliff Jones (8/17/2012)
I had no idea what the correct answer was and still don't.

+1

+1, with a lucky guess
Post #1347922
Posted Wednesday, August 22, 2012 8:24 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 7:41 AM
Points: 256, Visits: 479
lucky guess. I could only think of 3...


Post #1348445
« Prev Topic | Next Topic »

Add to briefcase «««1234»»

Permissions Expand / Collapse