SQL Server Data Types – Part 1

Home/Development, SQL Server/SQL Server Data Types – Part 1

SQL Server Data Types – Part 1

$4.00

Data types are used to defined what type of data a column can store. As like in any other language SQL server also has data types. This lab is divided into four exercises. The first exercise explains about CHAR and VARCHAR datatypes and performance differences between them. The second exercise explains about NVARCHAR, VARCHAR(n)
and VARCHAR(MAX) datatypes. The third exercise explains about IN row and OUT row storage when using VARCHAR(MAX). The fourth and final exercise explains about various integer datatypes and SPARSE column.

Exercise 1: CHAR vs VARCHAR datatypes
Exercise 2: NVARCHAR, VARCHAR(n)
and VARCHAR(MAX)
Exercise 3: VARCHAR(MAX), IN Row vs OUT Row storage
Exercise 4: Integer datatypes and Sparse column

Categories: ,

Description

Data types are used to defined what type of data a column can store. As like in any other language SQL server also has data types. This lab is divided into four exercises. The first exercise explains about CHAR and VARCHAR datatypes and performance differences between them. The second exercise explains about NVARCHAR, VARCHAR(n)
and VARCHAR(MAX) datatypes. The third exercise explains about IN row and OUT row storage when using VARCHAR(MAX). The fourth and final exercise explains about various integer datatypes and SPARSE column.

Exercise 1: CHAR vs VARCHAR datatypes
Exercise 2: NVARCHAR, VARCHAR(n)
and VARCHAR(MAX)
Exercise 3: VARCHAR(MAX), IN Row vs OUT Row storage
Exercise 4: Integer datatypes and Sparse column

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Content missing