Monday
March 30, 2015

Homework Help: sql

Posted by Anonymous on Monday, September 19, 2011 at 2:21pm.

Write a SELECT statement that returns four columns based on the InvoiceDate column of the Invoices table:
Use the CAST function to return the first column as data type varchar.
Use the CONVERT function to return the second and third columns as a varchar, using style 1 and style 10, respectively.
Use the CAST function to return the fourth column as data type real.

Answer this Question

First Name:
School Subject:
Answer:

Related Questions

programming - I need help with a C++ exercise. I need to write a code to display...
Excel Filtering - Hi I'm trying to filter data between 3 different columns. I ...
keybording and word processing - 7. to adjust a column's width in a table, you ...
SQL for Business - By using this table: CREATE TABLE Part ( Partid int IDENTITY...
Chemistry - I have 2 questions on columns used in the Gas Chromatography-Flame ...
English - I am ask to creat a table that lays out a day-by-day plan to use as a ...
software - What does this mean: "Using the columns feature,select the question ...
SQL for business help - I have no idea where to begin with this. A SQL statement...
Algebra - 1.What is the shape of the graph of any linear function? Answer-line 2...
PSY210 APPENDIX G - According to Sternberg, a person can experience eight ...

Members