MS-SQL Server - Architect Level

Architect Level

Char, Varchar Data Type Range

https://learn.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql?view=sql-server-ver16

Tinyint

Datatype Hierarchy and Datatype of Timestamp

Datatype Hierarchy and Datatype of Bigint

https://learn.microsoft.com/en-us/sql/t-sql/data-types/hierarchyid-data-type-method-reference?view=sql-server-ver16

Length also defined.

https://learn.microsoft.com/en-us/sql/t-sql/data-types/int-bigint-smallint-and-tinyint-transact-sql?view=sql-server-ver16

Year data type article

https://learn.microsoft.com/en-us/sql/t-sql/functions/year-transact-sql?view=sql-server-ver16

Datatype Hierarchy of all Data types

Money datatype is decimal

A separate partial monetary units and partial monetary money and smallmoney data types

Keys and Primary Constraints

https://learn.microsoft.com/en-us/sql/relational-databases/tables/primary-and-foreign-key-constraints?view=sql-server-ver16

Additionally,

Key Joins, Inner Join, Outer Join and Cross Join

Again partial monetary money and smallmoney datatypes are clearly differentiated.

In addition to this as shown above, there is also a concept of Composite PRIMARY KEY constraint.

Best Regards

T. Amit Vaid S.