Term
| Data types have a certain order, or precedence |
|
Definition
•This means when combining data types, implicit data conversion occurs, and the data type with the highest rank will be given priority. |
|
|
Term
|
Definition
| 8 bytes extremely large whole numbers |
|
|
Term
|
Definition
| max 8000 bytes good for storing hex and binary shorthand, security identifiers, or photo |
|
|
Term
|
Definition
|
|
Term
|
Definition
| good for storing binary of JPEG or Microsoft Word docs |
|
|
Term
|
Definition
| stores no less than a byte first bit consumes BYTE, second bit fits in said BYTE the ninth bit requires the addition of a new byte (makes sense) |
|
|
Term
|
Definition
a number can be stored as integer or character here
the numbers are seen as characters not numerics by SQL
char (5) uses 5 BYTES of space
even if less is used
non-Unicode |
|
|
Term
|
Definition
| 8000 max characters non-Unicode |
|
|
Term
|
Definition
| 3 bytes YYYY MM DD from 0001 year thru 9999 year |
|
|
Term
|
Definition
| 8 bytes Jan 1 1753 through Dec 31 9999 rounded .xxx increments of seconds |
|
|
Term
|
Definition
| 6-8 bytes YYYY MM DD hh mmm ss ns ns ns ns ns ns |
|
|
Term
|
Definition
|
|
Term
|
Definition
4 bytes
Jan 1 1900 through June 6 2079 |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
date 3 bytes YYYY MM DD from 0001 year thru 9999 year
datetime 8 bytes Jan 1 1753 through Dec 31 9999 rounded .xxx increments of seconds
datetime2 6-8 bytes YYYY MM DD hh mmm ss ns ns ns ns ns ns
datetimeoffset 8-10 bytes |
|
|
Term
|
Definition
aka numeric
precision and scales
precision of 5 and scale of 2
111.22
5 digits and 2 digits to the right of decimal
|
|
|
Term
|
Definition
only available on Enterprise edition
used for use of 5 to 22 bytes |
|
|
Term
|
Definition
|
|
Term
|
Definition
.NET common language runtime CLR data type
round earth coordinate system
stores ellipsoidal (round-earth) data
like GPS latitude and longitude coordinates |
|
|
Term
|
Definition
| Euclidean flat coordinate system |
|
|
Term
|
Definition
| organizational chart file system & graph of links between web pages |
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
|
|
Term
|
Definition
fixed length Unicode
used for Japanese Katakana and
German for example |
|
|
Term
|
Definition
|
|
Term
nvarchar
nvarchar(max)
real |
|
Definition
nvarchar
has
variable length Unicode max 4000 characters |
|
|
Term
|
Definition
lets you store values of different data types
but not variable like
char(max),
nchar(max),
text,
image,
sql_variant itself,
varbinary(max)
xml
ntext
timestamp
user defined data types
|
|
|
Term
|
Definition
16 bytes
NEWID() function
will create a globally unique identifier in hex |
|
|
Term
|
Definition
Filestream
Identity
Sysname
|
|
|
Term
|
Definition
For binary (big documents images etc)
unstructured data
To bring in externally stored data (like documents and pictures)
In the OS’s NTFS file system
DB and that file’s location is maintained by
24 byte pointer
This needs at server level usage, be enabled as follows:
EXEC sp_configure filestream_access_level, 2
|
|
|
Term
|
Definition
|
|
Term
|
Definition
Used by programmers for
TABLE COLUMNS,
VARIABLES,
STORED PROCEDURE PARAMETERS
They store object names
It’s like nvarchar(128)
However it is NOT NULL |
|
|
Term
|
Definition
Return a complete set of rows for app to use
You can return a cursor from a stored procedure
You can store a cursor in a variable
You CANNOT stored it in a table
THIS IS A VARIABLE
IT IS NOT A DATA TYPE |
|
|
Term
|
Definition
THIS IS A VARIABLE
THIS IS NOT A DATA TYPE
Returns datasets (ROWS & COLUMNS)
from stored procedures
Returns datasets (ROWS & COLUMNS)
from functions
It can also store tables in variables
You CANNOT store a table
in another table's column |
|
|
