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;
29 Cards in this Set
- Front
- Back
|
Boolean |
Bit data type |
|
|
Float |
Numeric data type used in the scientific community is considered an approximate number data type |
|
|
Money numeric |
Numeric data type is used in places where you input money or currency |
|
|
Datetime |
Data type is used to store date and time data in many different formats |
|
|
Integer int |
Numeric data type is used in math computations and is used when you do not require a decimal point |
|
|
Nvarchar |
Use for non-english language |
|
|
Varchar |
Character string data type is commonly used in databases where you are supporting English attributes |
|
|
Bit |
0-1 ;1 byte |
|
|
Tinyint |
0-255 ; 1 byte |
|
|
Smallint |
-32,000-32000 2 byte |
|
|
Int - |
2,000,000,000-2,000,000,000 ;4byte |
|
|
Bigint |
9 and lots of zeros to negative 9 and lots of zeros ; 8bytes |
|
|
Numeric/decimal |
Fixed upper limit, precision scale,; 5-17 bytes |
|
|
Smallmoney |
$214,748.3647; 4bytes |
|
|
Money |
$9 and lots of zeros to negative $9 and lots of zeros 8 bytes |
|
|
Date |
Track state from January 1st 0001 until December 31st 9999 |
|
|
Datetime |
Date and time of day based on 24-hour clock accurate up to 0.0033 seconds; range January 1st 1753 till December 31st 9999 |
|
|
Datetime 2 |
Date and time of day based on 24-hour clock; accurate to 100 nanoseconds; range January 1st 1753 to December 31st 9999 |
|
|
Datetimeoffset |
Adds ability to track time zones |
|
|
Small date time |
Date with time of day 24-hour clock seconds always show 00; accurate to minute;range January 1, 1900 to June 2079 |
|
|
Time |
Find the time of day using 24-hour clock does not track time zone |
|
|
Cast |
Source-vaule As destination-type cast(count AS float) |
|
|
Convert |
Date-type((length)), expression,(style)) convert (nvarchar(10), order Date, 101) |
|
|
Naming coventions |
PascalCase and camelCase |
|
|
Char (n) |
Ansi, 1 byte per character as stated by n |
|
|
Varchar(n) |
Ansi 1 byte per character used* |
|
|
Nchar(n) |
Unicode, 2 bytes per character used , supports more languages |
|
|
Nvarchar (n) |
Unicode, 2 bytes per character used to support more languages |
|
|
(n) |
Says how many characters |
