DATA TYPES IN SQL

DATA TYPES:
-----------
Data type represent the type of the data that a database object contain.
this data can be in the form of charecters or numbers.


INT
---
stores  onley the integer data
(whole numbers)


range: 2^31-1(2,147,483,647)



smallint:
---------
stores onley the integer values

range:2^15-1(32,767)



money:
-----
stores onley the money data

range:922,337,203,685,477.5808 to 922,337,203,685,477.5807



Datetime:
---------

stores  onley date and time data

range:
january 1,1753 through december 31,9999

time:
----
it accepts onley the Time data

range: 00:00:00:000000 through
23:59:59:9999999


char(n):
--------
it accepts 'n' charecters ,where n can be 1 to 8000
fixed  lengh charecter data

varchar(n)
-----------
it is used to store Variable length character data

n charecters,where n can be 1 to 8000

BINARY:
------
It is used to store Fixed length binary data

maximum length of 8000 bytes


Varbinary:
----------
It is used to store  variable length binary data

maximum length of 8000 bytes.

nvarchar:
---------
it is used to store the variable length Unicode data

max length of 4000 charecters.
©chantidodda