Wednesday
April 16, 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

SQL for business help - I have no idea where to begin with this. A SQL statement...
SQL server help! - A SQL statement is needed to create a stored procedure, which...
SQL for Business - By using this table: CREATE TABLE Part ( Partid int IDENTITY...
SQL - 1- A SQL statement is needed to create a stored procedure that has one ...
Computer Database SQL - Update the data in the Employees table so that employees...
software - What does this mean: "Using the columns feature,select the question ...
geometry - write the statement in symbols using the p and q given below. Then ...
Math - Select a variable (mean or proportion) of interest to you and collect or ...
math - Select a variable (mean or proportion) to determine if there is a ...
pLZ help - Select a variable (mean or proportion) to determine if there is a ...

Search
Members