SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


T-SQL Syntax


T-SQL Syntax

Author
Message
Cliff Jones
Cliff Jones
SSCarpal Tunnel
SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)SSCarpal Tunnel (4.3K reputation)

Group: General Forum Members
Points: 4275 Visits: 3648
I had no idea what the correct answer was and still don't.
sknox
sknox
SSCrazy
SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)SSCrazy (2.6K reputation)

Group: General Forum Members
Points: 2584 Visits: 2828
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.
jack a hummer
jack a hummer
SSC Rookie
SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)

Group: General Forum Members
Points: 28 Visits: 382
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.]



Thomas Abraham
Thomas Abraham
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2703 Visits: 2255
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
GPO
GPO
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1288 Visits: 1927
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

Toreador
Toreador
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2758 Visits: 8083
I got it right - but my list of possibilities was different from the questioner's :-)
Keld Laursen (SEGES)
Keld Laursen (SEGES)
Old Hand
Old Hand (366 reputation)Old Hand (366 reputation)Old Hand (366 reputation)Old Hand (366 reputation)Old Hand (366 reputation)Old Hand (366 reputation)Old Hand (366 reputation)Old Hand (366 reputation)

Group: General Forum Members
Points: 366 Visits: 202
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.
Ken Wymore
Ken Wymore
SSCertifiable
SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)SSCertifiable (5K reputation)

Group: General Forum Members
Points: 5044 Visits: 2371
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.
Revenant
Revenant
SSCertifiable
SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)SSCertifiable (7.3K reputation)

Group: General Forum Members
Points: 7294 Visits: 4857
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
KarenM
KarenM
SSC Veteran
SSC Veteran (278 reputation)SSC Veteran (278 reputation)SSC Veteran (278 reputation)SSC Veteran (278 reputation)SSC Veteran (278 reputation)SSC Veteran (278 reputation)SSC Veteran (278 reputation)SSC Veteran (278 reputation)

Group: General Forum Members
Points: 278 Visits: 524
lucky guess. I could only think of 3...



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search