Friday
November 28, 2014

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 ...
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...
Chemistry - I have 2 questions on columns used in the Gas Chromatography-Flame ...
Algebra - 1.What is the shape of the graph of any linear function? Answer-line 2...
Calculating Rate Constants - I'm really stuck with this one. Here's the rate ...
Ed. Tech - After creating a column heading and/or typing text within a column, ...
SQL - 1- A SQL statement is needed to create a stored procedure that has one ...

Search
Members