Home

	Expand Search

Reference Manual

Chapter 1: System and User-Defined Datatypes

Chapter 1

This chapter describes the Transact-SQL datatypes. Datatypes specify the type, size, and storage format of columns, stored procedure parameters, and local variables. Topics covered are:

• Datatype Categories
• Range and Storage Size
• Declaring the Datatype of a Column, Variable, or Parameter
• Datatype of Mixed-Mode Expressions
• Converting One Datatype to Another
• Standards and Compliance
• Exact Numeric Datatypes
• Approximate Numeric Datatypes
• Money Datatypes
• Timestamp Datatype
• Date and Time Datatypes
• Character Datatypes
• Binary Datatypes
• bit Datatypes
• sysname Datatype
• text and image Datatypes
• User-Defined Datatypes

Datatype Categories

Range and Storage Size

Declaring the Datatype of a Column, Variable, or Parameter

Datatype of Mixed-Mode Expressions

Converting One Datatype to Another

Standards and Compliance