Murach's sql server 2012 for developers
Chapter 8 How to work with data types

 

1.                  Write a SELECT statement that returns these columns from the Products table:

o  The ListPrice column

o  A column that uses the CAST function to return the ListPrice column with 1 digit to the right of the decimal point

o  A column that uses the CONVERT function to return the ListPrice column as an integer

o  A column that uses the CAST function to return the ListPrice column as an integer

2.                  Write a SELECT statement that returns these columns from the Products table:

o  The DateAdded column

o  A column that uses the CAST function to return the DateAdded column with its date only (year, month, and day)

o  A column that uses the CAST function to return the DateAdded column with its full time only (hour, minutes, seconds, and milliseconds) 

o  A column that uses the CAST function to return the DateAdded column with just the month and day

APlusGrades

Not Rated (0)

Status NEW Posted 21 Jul 2017 02:07 PM My Price 12.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â-----------  -----------Tha-----------nk -----------you----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m Â----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I

Not Rated(0)

• Buy Answer