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 2 of 4

««1 2 3 4 »»»

T-SQL Syntax

Rate Topic

Display Mode

Topic Options

Author

Message

SQL Surfer '66

Posted Friday, August 17, 2012 3:31 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, February 22, 2013 2:56 AM
Points: 225, Visits: 178

Only took a shot at this one (and missed). Today I don't have the time to search the documentation, but mostly because this was IMHO a bit to complex question.

Post #1346423

Gazareth

Posted Friday, August 17, 2012 4:01 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:53 AM
Points: 1,474, Visits: 2,342

Guessed & got it right - although I only answered so I could see the actual answer!
Like the question for making me think about it, the right/wrong was irrelevant really.
Would definitely like to see it expanded to an article if possible.

Cheers

Post #1346446

Stewart "Arturius" Campbell

Posted Friday, August 17, 2012 4:11 AM

Hall of Fame

Group: General Forum Members
Last Login: Monday, May 20, 2013 3:48 AM
Points: 3,125, Visits: 4,311

This was quite rough for a Friday question.
Inclined to agree with Hugo's opinion, though must add my well done to Jack for taking the time to investigate and submit the question. All things considered, I learned something out of it and the ensuing discussion.

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Post #1346449

(Bob Brown)

Posted Friday, August 17, 2012 5:32 AM

Say Hey Kid

Group: General Forum Members
Last Login: Friday, April 19, 2013 10:27 AM
Points: 690, Visits: 1,100

I agree. Not a good QotD. This should bring lots of discussion though and is very educational.

Post #1346483

NuNn DaddY

Posted Friday, August 17, 2012 6:39 AM

Old Hand

Group: General Forum Members
Last Login: Monday, April 15, 2013 7:02 AM
Points: 320, Visits: 331

Good Question - When in doubt, the answer is always 'C' :)

Post #1346509

sestell1

Posted Friday, August 17, 2012 6:53 AM

SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 3:34 PM
Points: 834, Visits: 1,211

Ouch, this one made my brain hurt.
Impossible to answer, but it did make me think.

Post #1346514

arthurolcot

Posted Friday, August 17, 2012 7:12 AM

SSCommitted

Group: General Forum Members
Last Login: Monday, May 20, 2013 9:04 AM
Points: 1,722, Visits: 1,404

I agree with Hugo. I thought of a couple of ways this could be done in my head before answering first, but didn't bother trying to research any other ways.. took an educated stab at an answer, but guessed wrongly. Knowing the answer now doesn't really serve me much use either going forward. Fair play to the author though for coming up with this and their research; it's just one that I won't remember for too long :)

Post #1346524

Lynn Pettis

Posted Friday, August 17, 2012 7:16 AM

SSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:17 PM
Points: 21,617, Visits: 27,450

It was a thinking question. I never even counted how many ways a variable could be set to a value. Having to leave out the basic SET (I don't count SET in the UPDATE statement the same way as it is required) and SELECT statements, how many ways are there? Yes, you could count some multiple times, but if you think about it, it's still the same (a duplicate, if you will).

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #1346530

Stuart Davies

Posted Friday, August 17, 2012 8:16 AM

SSCrazy

Group: General Forum Members
Last Login: Today @ 1:52 AM
Points: 2,476, Visits: 2,137

Koen Verbeeck (8/17/2012)

Great question, but way too difficult for a Friday Smile

+1

Kept on coming back to it through the day - still got it wrong!

-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

Post #1346567

EL Jerry

Posted Friday, August 17, 2012 8:37 AM

Hall of Fame

Group: General Forum Members
Last Login: Thursday, May 02, 2013 3:45 PM
Points: 3,748, Visits: 928

Good question, didn't have the time to investigate in BOL, so I took a guess and got it right.

Happy weekend everyone!!

"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan

Post #1346581

« Prev Topic | Next Topic »

32 posts, Page 2 of 4

««1 2 3 4 »»»

Permissions