SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Debasis Chakraborty / Data Type / Latest Posts

RE: Data Type

Lynn Pettis — Fri, 06 Feb 2009 06:30:03 GMT

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.

RE: Data Type

JF1081 — Thu, 05 Feb 2009 09:44:06 GMT

[quote][b]David (2/5/2009)[/b][hr][quote]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.[/quote]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.[url]http://msdn.microsoft.com/en-us/library/ms173829.aspx[/url]David[/quote]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.

RE: Data Type

DavidSimpson — Thu, 05 Feb 2009 08:36:25 GMT

[quote]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.[/quote]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.[url]http://msdn.microsoft.com/en-us/library/ms173829.aspx[/url]David

RE: Data Type

Seth Lynch — Thu, 05 Feb 2009 02:08:20 GMT

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.

Data Type

debasis.yours — Thu, 05 Feb 2009 01:20:52 GMT

Comments posted to this topic are about the item [B]Data Type[/B]