Өгөгдлийн төрлүүд

Ням, Гуравдугаар сар 25th, 2012

Өгөгдлийн төрөл

Утга

Санах ойд эзлэх зай

Bigint

 to

8 bytes

Int

-2147483648 to -2147483647

4 bytes

SmallInt

-32768 to 32767

2 bytes

TinyInt

0 to 255

1 bytes

Decimal or numeric

-1 to -1

10 bytes

Money

 to

8 bytes

SmallMoney

-214,7483648 to 214,7483647

4 bytes

Float

-1.79E+308 to 1.79E+308

4 bytes

DateTime

1753.1.1-9999.12.31

8 bytes

SmallDateTime

1900.1.1-2079.6.6

4 bytes

Char

8000 character (unicode авахгүй)

Varchar

8000 character (unicode авахгүй)

Text

2147483647 (unicode авахгүй)

Nchar

4000 character (unicode авна)

Nvarchar

4000 character (unicode авна)

Хариу үлдээх

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 / Өөрчлөх )

Twitter picture

You are commenting using your Twitter account. Log Out / Өөрчлөх )

Facebook photo

You are commenting using your Facebook account. Log Out / Өөрчлөх )

Google+ photo

You are commenting using your Google+ account. Log Out / Өөрчлөх )

Connecting to %s

%d bloggers like this: