• 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