• Great question, Paul!!

    Your production code will likely be more careful with these issues.

    Can I interpret this as "Your production code will likely completely avoid the use of SQLVariant"?

    (Okay, there may be circumstances where SQLVariant has its use, but I would strongly suggest only using it for data that is stored and retrieved but never operated upon in any other way).


    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/