---
title: "Write about Datatypes in SQL Server?"  
description: "Write about Datatypes in SQL Server?"  
author: "Ashutosh Kumar Verma"  
published: 2021-11-15  
updated: 2021-11-15  
canonical: https://www.mindstick.com/forum/156835/write-about-datatypes-in-sql-server  
category: "mssql server"  
tags: ["sql server", "sql"]  
reading_time: 2 minutes  

---

# Write about Datatypes in SQL Server?

Write about Datatypes in [SQL Server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server)?

## Replies

### Reply by Steilla Mitchel

**Datatype in [SQL](https://www.mindstick.com/articles/13115/types-of-keys-in-sql-or-oracle-database) [Server](https://www.mindstick.com/articles/43769/what-is-serverless-architecture-is-it-worth-switching-over):**

There are following types of data types in SQL, so let us know them in detail,

## Numeric Datatypes:

There are the following types of exact numeric data types in SQL,

**Int:** The range of int ranges from -2,147,483,648 to +2,147,483,648. It requires storage of 4 bytes.

**Bigint:** Range of Bigint ranges from -9,223,372,036,854,775,808 to +9,223,372,036,854,775,808. It requires 8 bytes of storage.

**Smallint**: Its range ranges from -32,768 to +32,768. It requires storage of 2 bytes.

**Tinyint:** Its range is from 0 to 255. It requires storage of 1 bytes.

**Bit:** The range of bit data type is from 0 to 1. It requires storage of 1 bytes.

**Money:** The range of this data type ranges from -922,337,203,685,477.5808 to +922,337,203,685,477.5808. It requires 8 bytes of storage.

**Smallmoney:** The range of this data type ranges from -214,748.3648 to +214,748.3648. It requires 4 bytes.

**Decimal:** Its range ranges from -10^38+1 to +10^38+1.

**Numeric:** Its range also ranges from -10^38+1 to +10^38+1.

## Datetime Datatype:

The following types of datetime data types are there in SQL,

**Date**: This data type stores the value of year, month, and day. It requires 3 bytes of storage.

**Time:** This data type stores the value of hour, minute, and second.

**Smalldatetime:** This data type requires 8 bytes of storage.

## Character Datatype:

The following types of character data types are there in SQL.

1 Char.

2Varchar.

3 Varchar(MAX).

4 Text.

## Unicode Character Datatype:

There are following types of Unicode characters.

1 nchar

2 nvarchar.

3 nvarchar(max).

4 ntext.

## Binary Datatype:

1 Binary.

2 Varbinary.

3 Varbinary(max).

4 Image.

## Boolean Datatype:

There are only two value contain Boolean data type that is ‘true’ or ‘false’.

## \


---

Original Source: https://www.mindstick.com/forum/156835/write-about-datatypes-in-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.