Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
11 Cards in this Set
- Front
- Back
|
whole number data types
|
used to store fixed-length whole numbers.
exs) bigint,smallint,int. |
|
|
bigint
|
stores up to 8 bytes worth of numbers.
|
|
|
smallint
|
stores 2 bytes worth of numbers ie from +- 32,000. 16th bit holds negative sign
|
|
|
int
|
stores 4 bytes worth of numbers i.e. up to +-2.1 billion
|
|
|
how many bits in a byte?
|
there are 8 bits in it
|
|
|
fixed-point number data types
|
the data types that includes decimals. Is stored digit by digit and can take longer to manipulate than other data types.
|
|
|
decimal[(precision[,scale])] or numeric[ " " ]
|
command that sets the amount of decimal places and the total amount of digits allowed in a number. Is a fixed point data type.
|
|
|
SET NUMERIC_ROUNDABORT{OFF|ON}
|
sets whether rounding will be allowed if it results in a loss of precision
|
|
|
real data type
|
a floating point data type
|
|
|
MONEY and SMALL MONEY commands
|
the money data types
|
|
|
DATETIME and SMALLDATETIME
|
stores dates and time to different accuracies (within a minute or 1/300th o a minute)
|
