Artikel Ilmu Komputer

DATA TYPE

Data type applied to define data type owned by server object like Variable, parameters, column ( field). Data which can be packed into our database it is of course all kinds. In MS-SQL Server 2000 supporting assorted of data type.

NUMERIC

1. bigint
Integer value with value from - 2^63 (- 9223372036854775808)
to 2^63-1 ( 9223372036854775807).

2. int
Integer value with value from - 2^31 (- 2,147,483,648) to 2^31 - 1 ( 2,147,483,647).

3. small int
Integer value with value out of 2^15 (- 32,768) until 2^15 - 1 ( 32,767).

4. tinyint
Integer value with value from 0 to 255.

5. bit
Integer value with value 1 or 0.

6. Decimal and Numeric
Numeral with permanent accuration from - 10^38 + 1 to 10^38 – 1.

MONEY

1. money
Data with value currency - 2^63 (- 922,337,203,685,4775808)
through 2^63 - 1 (+ 922,337,203,685,4775807)

2. Small money
Data with currency value - 214,7483648 through + 214,7483647

NUMERIC PRECESSION

1. Float
Precession number from - 179E + 308 until 179E + 308.

2. real
Precession number from - 340E + 38 until 340E + 38.

DATE TIME

1. date time
Date and time from January 1, 1753, until December 31, 9999,
with accuration to 333 mills second

2. smalldatetime
Date and time from January 1, 1900, until June 6, 2079, with accuration one minutes.

STRINGS

1. Char
Field contains character of the size permanent length with maximum length 8,000 characters.

2. varchar
Field contains character with erratic measure length with maximum length 8,000 characters.

3. Text
Variable contains character with footage to 2^31 - 1 ( 2,147,483,647) character.