Home Forums Database Design Design Ideas and Questions Would you use sql_variant? RE: Would you use sql_variant?

  • January 29, 2008 at 10:15 am

    #772970

    Ahhh... Interesting that the following statement will work perfectly:

    INSERT INTO TESTVARIANT (ITEM) (Select Convert(money,(15)))

    And SUM() still will not work with the datatype. I thought it would. In fact, I thought the whole point of Sql_Variant was that you wouldn't have to do conversions when you pulled the data back out of the column.

    Well, lookee there. I learned something new today despite my efforts not to. @=)

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.