T-SQL Syntax

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Jack Hummer » T-SQL Syntax

32 posts, Page 3 of 4

«««1 2 3 4 »»

T-SQL Syntax

Rate Topic

Display Mode

Topic Options

Author

Message

Cliff Jones

Posted Friday, August 17, 2012 10:05 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 7:22 AM
Points: 3,397, Visits: 3,406

I had no idea what the correct answer was and still don't.

Post #1346644

sknox

Posted Friday, August 17, 2012 11:33 AM

Ten Centuries

Group: General Forum Members
Last Login: 2 days ago @ 9:31 AM
Points: 1,040, Visits: 1,356

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

jack a hummer

Posted Friday, August 17, 2012 2:15 PM

Grasshopper

Group: General Forum Members
Last Login: Monday, May 13, 2013 9:15 AM
Points: 20, Visits: 227

Hugo - I appreciate your comments, and probably agree with most of them. Smile

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

Thomas Abraham

Posted Friday, August 17, 2012 7:06 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:04 PM
Points: 1,150, Visits: 1,455

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. Smile

Please don't go. The drones need you. They look up to you.

Post #1346792

GPO

Posted Saturday, August 18, 2012 3:43 PM

SSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 3:53 PM
Points: 648, Visits: 1,303

Cliff Jones (8/17/2012)

I had no idea what the correct answer was and still don't.

One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important.
Bertrand Russell

Post #1346887

Toreador

Posted Monday, August 20, 2012 3:02 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, May 17, 2013 9:52 AM
Points: 1,356, Visits: 4,761

I got it right - but my list of possibilities was different from the questioner's Smile

Post #1347035

Keld Laursen (VFL)

Posted Monday, August 20, 2012 3:36 AM

SSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 7:36 AM
Points: 245, Visits: 148

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