(function openLouie() { let louie = document.getElementById("Dropdown-Toggle-14"); louie.classList = "host-toggle w-dropdown-toggle w--open"; console.log(louie); })();
Data Types

Chapter 3: Data Types 

Section 3.1: DECIMAL and NUMERIC 

Getting numbers in specific precision and scale. 

DECIMAL and NUMERIC are functionally same. 

Syntax: 

Example:

Section 3.2: FLOAT and REAL 

Approximation of numbers in data types. 

Section 3.3: Integers 

Data types that use exact numbers, divided between ranges and storage sizes.

Section 3.4: MONEY and SMALLMONEY 

Data types that represent money and currency

Section 3.5: BINARY and VARBINARY 

Binary data types that have either fixed or variable lengths. 

Syntax:

n_bytes can differ from 1 to 8000 bytes. max indicates that the maximum storage space is 2^31-1. 

Examples: 

Section 3.6: CHAR and VARCHAR 

String data types that have either fixed or variable lengths. 

Syntax: 

Examples:

Section 3.7: NCHAR and NVARCHAR 

UNICODE String data types that have either fixed or variable lengths. 

Syntax:

You can use MAX for very long strings longer than 8000 characters. 

Section 3.8: UNIQUEIDENTIFIER 

A 16-byte GUID / UUID. 

Simplicity Meets High Performance

Free edition subscription
Keep your work
No credit card required to try