Data Type

  • debasis.yours

    SSCrazy

    Points: 2782

    Comments posted to this topic are about the item Data Type

  • Seth Lynch

    SSCrazy

    Points: 2915

    I'm not sure 'Geometry and Geography' are a new data type - they are two different data types.

    Perhaps just one should have been put in the question rather than grouping them.

  • DavidSimpson

    Hall of Fame

    Points: 3539

    I was not 100% sure of my answer, but I picked the one that was not capitalized likt the others. And I have never seen a data type with an underscore in it before.

    The sql_variant data type was introduced in SQL Server 2000. Interesting data type but I've not had a use for it yet myself.

    http://msdn.microsoft.com/en-us/library/ms173829.aspx

    David

  • JF1081

    SSC Eights!

    Points: 982

    David (2/5/2009)


    I was not 100% sure of my answer, but I picked the one that was not capitalized likt the others. And I have never seen a data type with an underscore in it before.

    The sql_variant data type was introduced in SQL Server 2000. Interesting data type but I've not had a use for it yet myself.

    http://msdn.microsoft.com/en-us/library/ms173829.aspx

    David

    oops, meant to edit my last post and ended up deleting it.

    I did some research on it. I have learned more from the questions on this site than most anywhere else. Keep up the good questions.

  • Lynn Pettis

    SSC Guru

    Points: 442118

    I've used the sql_variant type once, in a TMR database used to evaluate data in other databases. I needed to be able to store data from other databases without knowing up front what datatypes would be used to evaluate data frequency, min/max values, etc.

    Doesn't work for blob fields, but for what we were using it for, it worked fine.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply