SQL Server data types are categorized into:
Numeric Types: INT, BIGINT, SMALLINT, TINYINT, DECIMAL, NUMERIC, FLOAT, REAL, MONEY
String Types: VARCHAR, NVARCHAR, CHAR, NCHAR, TEXT, NTEXT
Date/Time Types: DATE, TIME, DATETIME, DATETIME2, SMALLDATETIME, DATETIMEOFFSET
Binary Types: BINARY, VARBINARY, IMAGE
Other Types: BIT, UNIQUEIDENTIFIER, XML, JSON (SQL Server 2016+)
Example:
CREATE TABLE Employee (
ID INT,
Name NVARCHAR(50),
Salary DECIMAL(10,2),
HireDate DATETIME
);
Rewriting in plainer words…
This answer doesn't lend itself to a diagram - it reads best . No credits were charged.
Why there's no diagram: “”
The interactive diagram is below the answer - jump to diagram ↓ · Below it, the related concept . Jump to it ↓
The diagram below the answer is the concept . Jump to it ↓
Tailored explanation · switch back to · ·
What should the new diagram focus on?