Creating Data Types and tables

Exact and approximate numeric data types
Exact – decimal, numeric
Approximate – float, real
Character data types
Fixed – nchar
Variable – nvarchar
Date and time data
Dates and times – datetime, smalldatetime
Row version – timestamp
Large data values
Large object type – text, image
max specifier – varchar(max), nvarchar(max), varbinary(max)