O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Data Types

A spreadsheet and a database are very similar at a very basic level. Both spreadsheets and databases have rows and columns where you store data. Both spreadsheets and databases allow you to locate, retrieve, and manipulate data in a variety of ways. One of the most fundamental differences between a database and a spreadsheet is that a database provides and enforces a structure upon the data that is stored. While it is possible to mix character, numeric, and date data into a single column within a spreadsheet, a database prevents this type of undefined structure through the use of data types assigned to a column. Even though a data type is not generally referred to as a constraint, a data type is the most fundamental constraining element ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required