Thursday, November 22, 2012

sql server data types 2012

Sql server  data types 2012


Sql-Server 2012 has following data types
data typesname

Data Type
Values
tinyint
1 byte  values 0-255
Smallint
2 bytes  values  -32768 to 32767
int
4 bytes values -2147483648 to 2147483647
bigint
8 bytes  values -9223372036854775808 to 9223372036854775807
float

real

Binary

varbinary

Char

Varchar

bit

Smallmoney

money

Numeric

Date

SmallDatetime

Datetime

TimeStamp

Time(7)

DateTime2

DateTimeOffSet

image

Hierarchyid

Sql_variant

xml

Uniqueidentifier

No comments:

Post a Comment