Want to really know about different data types in SQL ? Here its for you :


There are 7 types of data types which are native for SQL,they are :

1. Exact numeric – bigint,int,smallint,tinyint,decimal,numeric.
2. Approximate numeric – float,real.
3. Monetary – money,smallmoney.
4. Date and Time – datetime,smalldatetime.
5. Binary – binary(n),varbinary(n)varbinary(max),image.
6. Character – char(n),varchar(n),nchar(n),nvarchar(n),varchar(max),nvarchar(max),text,ntext.
7. Special purpose – bit,sql_variant,timeStamp,XML,table,cursor,uniqueidentifier.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s