Chapter 8 Application

Question 1

Use FORMAT(number,decimal) in a select statement to return Department rows with salary appearing as an integer.

Answer 1

Select dName, format(salary,0) from department;

Question 2

Use CAST(expression AS castType*) in a select statement to return Department rows with salary appearing as an integer.

Answer 2

Select dName, cast(salary as signed) from department;

Question 3

Use CONVERT(expression, castType) in a select statement to return Department rows with salary appearing as an integer.

Answer 3

Select dName, convert(salary, signed) from department;