This chapter builds on the last by covering the data types available in SQL Server 2000. Understanding the available data types in SQL Server will ensure that your table columns and variables are properly defined and can accommodate the full range of values they are expected to hold. In addition, I’ll cover some multi-lingual issues and explain what data types are required to support international applications. The chapter concludes with a section that covers SQL Server’s ability to implicitly convert one data type to another. Understanding implicit conversion should help you understand how SQL Server can perform what may seem like illogical operations on certain data.


Data Type Database Object Storage Size Data Page Integer Data 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Garth Wells 2001

Authors and Affiliations

  • Garth Wells
    • 1
  1., Inc.USA

Personalised recommendations