Home Forums Article Discussions Article Discussions by Author Discuss content posted by Tom Thomson Variant order 1 RE: Variant order 1

  • November 30, 2011 at 8:49 am

    #1414734

    KWymore (11/30/2011)

    I have not yet seen sql variants actually used in production but then again, we have very few 2008 instances up and running.

    There is no connection between sql_variant and SQL Server 2008. This data type has been around since at least SQL Server 2000. (I think even before that, but I could not find evidence of that, and I'm not sure if I can trust my memory anymore).

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/