SQL Server 2008 R2 Data Types

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Kenneth Fisher » SQL Server 2008 R2 Data Types

11 posts, Page 1 of 2

1 2 »»

SQL Server 2008 R2 Data Types

Rate Topic

Display Mode

Topic Options

Author

Message

Kenneth.Fisher

Posted Wednesday, February 22, 2012 12:01 AM

Hall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 1:16 PM
Points: 3,367, Visits: 1,567

Comments posted to this topic are about the item SQL Server 2008 R2 Data Types

Kenneth Fisher
I strive to live in a world where a chicken can cross the road without being questioned about its motives.
--------------------------------------------------------------------------------
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Link to my Blog Post --> www.SQLStudies.com

Post #1255721

jeffrey.henninger

Posted Wednesday, February 22, 2012 6:12 AM

Valued Member

Group: General Forum Members
Last Login: Monday, August 06, 2012 9:24 AM
Points: 54, Visits: 17

Good information. You forgot to mention the time component of the Datetime data type (00:00:00 through 23:59:59.997). Otherwise, thanks for sharing!

Post #1255881

roger.plowman

Posted Wednesday, February 22, 2012 6:59 AM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 7:11 AM
Points: 317, Visits: 619

Very, very helpful. Maybe Microsoft should have a set of tables like this one at the front of the BOL! :)

Post #1255926

Jeff York-176691

Posted Wednesday, February 22, 2012 7:28 AM

Valued Member

Group: General Forum Members
Last Login: Friday, April 26, 2013 11:47 AM
Points: 63, Visits: 152

Nice work, thank you!

Post #1255959

Mike Dougherty-384281

Posted Wednesday, February 22, 2012 7:48 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 9:18 AM
Points: 198, Visits: 682

"A column of type sql_variant may contain rows of different data types."

fwiw: I parse that sentence at least two ways. I believe the correct meaning is that the field value on any particular row may contain a different data type than some other row.

It might also be taken as: the sql_variant type is something similar to an array that could contain rows of data. I'm sure there are a few programmers out there who would like to store a complex object like an array in a single row.

My assumption is that most DBA here simply avoid this type. I'm curious to know how/why this type is being used in the real world - and whether it can be indexed.

Post #1255990

simon_kingston

Posted Wednesday, February 22, 2012 8:23 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 9:34 AM
Points: 4, Visits: 174

Very helpful! Thanks Kenneth. One minor spelling correction - "spacial" should be "spatial".

Post #1256036

Kenneth.Fisher

Posted Wednesday, February 22, 2012 10:46 AM

Hall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 1:16 PM
Points: 3,367, Visits: 1,567

Thanks for all of the great comments. I'm working on having the one spelling error corrected. I should also point out (if anyone didn't already notice) that the data type names have links to the BOL article about that particular data type.

I'll probably end up doing one of these for 2012 and I'll make sure to add in all of the corrections mentioned here.

Thanks
Kenneth

Kenneth Fisher
I strive to live in a world where a chicken can cross the road without being questioned about its motives.
--------------------------------------------------------------------------------
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Link to my Blog Post --> www.SQLStudies.com

Post #1256150