SQL Server > Table

Data types in SQL Server

Which data type should be used for what type of data in SQL Server?

Following are the data type and its range in SQL Server

To store any kind of integer data, we can use following data types. Notice the Range column that is the min and max limit of data we can store.

To store any decimal or numeric data, we can use following data types.

Numeric maps to the Decimal data type of the .NET and it is functionally equivalent to the Decimal data type.

To store small number with floating decimal point, float data type can be used.

Float – maps to the Single data type of .NET

Real – maps to the Double data type of the .NET

To store monetary data, money or smallmoney data type can be used.

To select a data type for a column (while designing) in the database table, click on the Data type dropdown and select it.

 Views: 1659 | Post Order: 23

Write for us