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


Variant Order 3


Variant Order 3

Author
Message
Christian Buettner-167247
Christian Buettner-167247
SSCertifiable
SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)

Group: General Forum Members
Points: 5249 Visits: 3889
L' Eomot Inversé (12/12/2011)

What's the most important use of SQL_VARIANT order? Well, in my experience its main use is in generating T-SQL trivia questions for use as QotD - we've had 5 since 1st November (1 from Paul, 1 from bitbucket, and 3 from me).

True, true :-)

Best Regards,

Chris Büttner
Christian Buettner-167247
Christian Buettner-167247
SSCertifiable
SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)

Group: General Forum Members
Points: 5249 Visits: 3889
john.arnott (12/12/2011)
So nearly two-thirds of respondants so far are smarter than I. They wouldn't have just run the code and clicked the corresponding option now, would they?

Well, you can assume that noone knew the answer before running the code.
I for myself decided pretty quickly that I do not know the answer (by heart), and that learning the correct answer from BOL or other sources will not advance my SQL skills significantly. So I decided to shortcut by running the code directly.
And no, I usually dont short-cut, only in such special occasions.

Hope this does not disappoint you.

Best Regards,

Chris Büttner
rfr.ferrari
rfr.ferrari
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2159 Visits: 13639
good question tom!!!!
thanks!!!!


rfr.ferrari
DBA - SQL Server 2008
MCITP | MCTS

remember is live or suffer twice!
the period you fastest growing is the most difficult period of your life!

john.arnott
john.arnott
Hall of Fame
Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)Hall of Fame (3.6K reputation)

Group: General Forum Members
Points: 3566 Visits: 3059
Christian Buettner-167247 (12/13/2011)
john.arnott (12/12/2011)
So nearly two-thirds of respondants so far are smarter than I. They wouldn't have just run the code and clicked the corresponding option now, would they?

Well, you can assume that noone knew the answer before running the code.
I for myself decided pretty quickly that I do not know the answer (by heart), and that learning the correct answer from BOL or other sources will not advance my SQL skills significantly. So I decided to shortcut by running the code directly.
And no, I usually dont short-cut, only in such special occasions.

Hope this does not disappoint you.

Not at all. Rather, I'm kicking myself for spending so much time trying to track down the answer when I knew that Tom would have it for me.
Uripedes Pants
Uripedes Pants
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1189 Visits: 4519
WHAT?!?!?? you mean that people run the code then take credit for the answer? I guess I don't have to feel guilty when I google the QOTD any more. :-P
Tom Thomson
Tom Thomson
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25825 Visits: 12494
Uripedes Pants (12/13/2011)
:-P

I'm going completely off topic:

With someone using that nickname (and this late at night, with perhaps too many jars downed in the course a minor celebration) I just can't resist asking Γιατί ο Ευριπίδης ασθμαίνω? Using Greek when asking someone using Euripides as a nickname seems appropriate, even if my Greek is that bad.

And that led to an increase of my distrust in modern machine translators (they seem worse than what Siemens had about 20 years ago).

My Greek is extremely limited, not quite totally nonexistent but extremely close to that (closer than you probably think - anyway, I hadn't a clue what the Greek for "pants" - in any of its meanings - might be) so I tried an automatic translation first; it insisted on using σώβρακο or παντελόνι and the second option of those options made me suspicious; and a quick dictionary check indicated that the first option was no better. Although I trust Google translate not one jot, I tried that next - and got Γιατί είναι ότι ο Ευριπίδης παντελόνι, which is absolute pants; then I tried asking google translate to translate "Pourquoi Euripide halète-t-il ?" to Greek, and got those παντελόνι again (in "Γιατί ο Ευριπίδης παντελόνι εκεί", which to me suggests that it does some of its French to Greek by translating French to English and then English to Greek, because as well as "pants" the Google English translation for that phrase has a spurious "there" in it, which is maybe where that spurious "εκεί" in the Greek comes from).

Since I am totally unable to conjugate Greek verbs and the machine translators failed me and my beginners modern greek text book is more than a thousand miles away (and it would probably take me several hours to find it even if I was there - it's years since I decided ancient and modern Greek were two languages too many) I ended up with the above words as my attempt at asking the obvious question, but I guess anyone calling himself Euripedes should be able to make sense out of my utterly awful Greek.

I have a niggling suspicion that the machine translations - even Google's - conformed to the intent of the nickname, unless perhaps that particular metaphor is not used in Greek. But what I asked them to translate was using "pant" as a verb, and translating something which syntactically has to be a verb as if it were an unrelated noun was a gross failure of the machine translators (and Google's screw-up translating from French was a total failure, since there's no way "halète" can bear that meaning).

Tom

Hugo Kornelis
Hugo Kornelis
SSCoach
SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)SSCoach (18K reputation)

Group: General Forum Members
Points: 18683 Visits: 12426
(still off-topic)

Tom, I fooled around a bit with both Bing Translator and Google Translate, and I am convinced that they both suffer from the same bug, introduced by a combination of using English as an intermediate language and not looking at words in their grammatical context.
I tried to translate the sentences "Euripides hijgt" and "Waarom hijgt Euripides?" to Greek, and got the παντελόνι translation for both variations and on both sites.

I then tried "Waarom is Euripides aan het hijgen?" (Dutch for "Why is Euripides panting?"). Bing Translator gave me the utterly unhelpful "Γιατί είναι Ευριπίδη, για να το panting;", but Google Translate seems to do better here: "Γιατί είναι ο Ευριπίδης να λαχανιάζω;". Translating the latter back to Dutch on Bing Translator was truly hilarious - the result was "Waarom is Euripides aan bladerdeeg?" (Why is Euripides on puff pastry?). My guess is that the translation was again indirect, that λαχανιάζω was translated as puff rather than pant, and that the word puff was utterly misunderstood for the second phase (English to Dutch) of the translation.


Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
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