Monday
September 22, 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...
Algebra - 1.What is the shape of the graph of any linear function? Answer-line 2...
Chemistry - I have 2 questions on columns used in the Gas Chromatography-Flame ...
Calculating Rate Constants - I'm really stuck with this one. Here's the rate ...
chemistry - Reaction 1: I2(aq)Cu^+2(aq) Ag^+(aq)Br2(aq) Column 1---Column 2---...
SQL - 1- A SQL statement is needed to create a stored procedure that has one ...

Search
Members