February 5, 2009 at 2:08 am
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.
February 5, 2009 at 8:36 am
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
February 5, 2009 at 9:44 am
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.
February 6, 2009 at 6:30 am
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 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply