Appendix C. T-SQL Datatypes

As explained in Lesson 1, “Understanding SQL,” datatypes are basically rules that define what data may be stored in a column and how that data is actually stored.

Datatypes are used for several reasons:

Image Datatypes enable you to restrict the type of data that can be stored in a column. For example, a numeric datatype column only accepts numeric values.

Image Datatypes allow for more efficient storage, internally. Numbers and date/time values can be stored in a more condensed format than text strings.

Datatypes allow for alternate ...

Get Sams Teach Yourself Microsoft® SQL Server T-SQL in 10 Minutes, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.