SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by Kenneth Fisher / SQL Server 2008 R2 Data Types / Latest Posts

RE: SQL Server 2008 R2 Data Types

Neha05 — Fri, 03 Aug 2012 05:55:10 GMT

Thanks Kenneth for sharing :-)

RE: SQL Server 2008 R2 Data Types

Cliff Jones — Fri, 24 Feb 2012 09:39:23 GMT

Very nice. Thanks for sharing this.

RE: SQL Server 2008 R2 Data Types

Possinator — Thu, 23 Feb 2012 15:46:13 GMT

Thanks! Very helpful. I made myself a Word version. It's attached if anyone wants it.

RE: SQL Server 2008 R2 Data Types

Jagadish Kumar Punnapu — Wed, 22 Feb 2012 17:31:43 GMT

Thanks for sharing this info Kenneth...

RE: SQL Server 2008 R2 Data Types

Kenneth.Fisher — Wed, 22 Feb 2012 10:46:57 GMT

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.ThanksKenneth

RE: SQL Server 2008 R2 Data Types

simon_kingston — Wed, 22 Feb 2012 08:23:50 GMT

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

RE: SQL Server 2008 R2 Data Types

Mike Dougherty-384281 — Wed, 22 Feb 2012 07:48:03 GMT

"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.

RE: SQL Server 2008 R2 Data Types

Jeff York-176691 — Wed, 22 Feb 2012 07:28:39 GMT

Nice work, thank you!

RE: SQL Server 2008 R2 Data Types

roger.plowman — Wed, 22 Feb 2012 06:59:24 GMT

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

RE: SQL Server 2008 R2 Data Types

jeffrey.henninger — Wed, 22 Feb 2012 06:12:44 GMT

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!

SQL Server 2008 R2 Data Types

Kenneth.Fisher — Wed, 22 Feb 2012 00:01:29 GMT

Comments posted to this topic are about the item [B]SQL Server 2008 R2 Data Types[/B]