Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - Categories of Data Types Used by SQL Server
(Continued from previous topic...)
How Many Categories of Data Types Used by SQL Server?
A data type is an attribute that specifies the type of data that the object can hold: integer data,
character data, monetary data, date and time data, binary strings, and so on.
In SQL Server 2005, each column, local variable, expression, and parameter has a related data type.
Data types in SQL Server 2005 are organized into the following categories:
- Exact Numerics - BIGINT, INT, SMALLINT, TINYINT, BIT, DECIMAL, NUMERIC, MONEY, and SMALLMONEY.
- Approximate Numerics - FLOAT, and REAL.
- Date and Time - DATETIME and SMALLDATETIME.
- Character Strings - CHAR, VARCHAR, and TEXT.
- Unicode Character Strings - NCHAR, NVARCHAR, and NTEXT
- Binary Strings - BINARY, VARBINARY, and IMAGE.
- Other Data Types - CURSOR, SQL_VARIANT, TABLE, UNIQUEIDENTIFIER, TIMESTAMP, and XML.
(Continued on next topic...)
- What Is SQL Language?
- What Is Transact-SQL Language?
- What Is a Transact-SQL Statement?
- How To Start and End Transact-SQL Statements?
- How To Enter Comments in Transact-SQL Statements?
- What Is a Transact-SQL Statement Batch?
- What Happens to a Statement Batch If There Is a Compilation Error?
- How To Use GO Command in "sqlcmd"?
- How To Create User Messages with PRINT Statements?
- How Many Categories of Data Types Used by SQL Server?
- What Are Exact Numeric Data Types?
- What Are Approximate Numeric Data Types?
- What Are Date and Time Data Types?
- What Are Character String Data Types?
- What Are Unicode Character String Data Types?
- What Are Binary String Data Types?
- What Are the Differences between CHAR and NCHAR?
- What Are the Differences between CHAR and VARCHAR?
- What Are the Differences between DECIMAL and FLOAT?