SQL Server 2005 has the following data types available:
- Exact Numerics
- BIGINT
- INT
- SMALLINT
- TINYINT
- BIT bit
- DECIMAL
- NUMERIC
- MONEY
- SMALLMONEY
- Approximate Numerics
- FLOAT
- REAL
- Date and Time
- DATETIME
- SMALLDATETIME
- Character
- CHAR
- VARCHAR
- TEXT
- Unicode Character
- NCHAR
- NVARCHAR
- NTEXT
- Binary
- BINARY
- VARBINARY
- IMAGE
- Other
- CURSOR
- SQL_VARIANT
- TABLE
- TIMESTAMP
- UNIQUEIDENTIFIER
- XML