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

Collation and SQL_VARIANT Expand / Collapse
Author
Message
Posted Tuesday, November 1, 2011 6:45 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, December 22, 2014 12:04 PM
Points: 1,639, Visits: 1,987
Rich Weissler (11/1/2011)
Only row 2 matches the explicit Latin1_General_CI_AS collation in the query.

I see one row. Which is the other one?


That's row number 2, not two rows.
Post #1198625
Posted Tuesday, November 1, 2011 6:51 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 1:32 PM
Points: 581, Visits: 733
Great question that made me think. Great explanation.

Thanks,

Matt
Post #1198633
Posted Tuesday, November 1, 2011 7:01 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, December 23, 2014 7:18 PM
Points: 7,930, Visits: 9,654
SQL Kiwi (11/1/2011)
L' Eomot Inversé (11/1/2011)
Excellent question.

I wonder if there's another on sql_variant in the pipleline?

Not at this stage, at least not by me. I was going to do one based on the weird sort order of SQL_VARIANT, but it's too obtuse even for me

That's the very one I was wondering about, as it seems a natural next question (as you've defined a UNIQUE constraint on a variant column, there must be a total order on SQL_variant to produce the index that supports that constraint. It's not really all that obtuse, if I remember the ordering rules correctly. In fact I'm tempted to ask that one myself if you are not going to. Or even ask two or three questions on it (on second thoughts, maybe that I'm contemplating two or three questions means it is a bit obtuse).


Tom
Post #1198637
Posted Tuesday, November 1, 2011 7:23 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, December 1, 2014 9:55 AM
Points: 1,823, Visits: 905
cfradenburg (11/1/2011)That's row number 2, not two rows.

Doh! That's clear as day now. Thank you! (Both for the answer, and the patience.) (I learned two things today! First, a little more about SQL_Variant. Second, don't try to comprehend the QotD answer before coffee.)
Post #1198648
Posted Tuesday, November 1, 2011 7:41 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: Monday, November 10, 2014 12:05 PM
Points: 3,969, Visits: 3,648
Very interesting question.
Post #1198658
Posted Tuesday, November 1, 2011 8:25 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176, Visits: 778
Thanks Kiwi! Another great great question that had me looking more closely at something I hadn't yet tinkered with too much. Cheers mate!
Post #1198715
Posted Tuesday, November 1, 2011 9:08 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 6:12 PM
Points: 18,082, Visits: 16,117
cool question



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1198744
Posted Tuesday, November 1, 2011 9:20 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: Wednesday, December 24, 2014 9:24 AM
Points: 3,355, Visits: 3,658
Britt Cluff (11/1/2011)
Wow, did I have to think on this one. Thanks for the interesting question.


+ 1 - Thanks


-------------------------------
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 #1198753
Posted Tuesday, November 1, 2011 9:23 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: 2 days ago @ 9:42 AM
Points: 3,429, Visits: 2,039
Interesting stuff, thanks!
Post #1198756
Posted Tuesday, November 1, 2011 9:49 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, December 19, 2014 6:02 AM
Points: 1,012, Visits: 1,008
Nice one, thanks

Iulian
Post #1198777
« Prev Topic | Next Topic »

Add to briefcase «««12345»»»

Permissions Expand / Collapse