Watch the videos on SQL Training online. SQL Trim, Rtrim, Ltrim, SQL Substring, SQL Like Filter, SQL Convert Function, Cast Function, How to filter Datetime in SQL Server 

NOTE: ONLY RETURN THE TOP 10 ROWS!

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

a) The ListPrice column

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

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

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

Query goes here

Screen Shot goes here

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

a) The DateAdded column

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

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

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

Query goes here

Screen Shot goes here

3. Write a SELECT statement that returns these columns from the db1.MyGuitarShop.Products table:

a) The OrderDate column

b) A column that uses the CONVERT function to return the OrderDate column in this format: MM/DD/YYYY. In other words, use 2-digit months and days and a 4-digit year, and separate each date component with slashes.

c) A column that uses the CONVERT function to return the OrderDate column with the date, and the hours and minutes on a 12-hour clock with an am/pm indicator.

d) A column that uses the CONVERT function to return the OrderDate column with just the time in a 24-hour format, including the milliseconds.

Query goes here

Screen Shot goes here

Leave a Reply

Your email address will not be published. Required fields are marked *