Write a SELECT statement - Exercise

This exercise is worth 3 points and is scored automatically. When you are finished, just click the Submit button to receive full credit.

• Background and Overview
  Write a SELECT statement that will return all the columns of data in the CustTable of the VirtualBookShelf database.
• Download Files: You will need the file sqlfun.asp to do this exercise. This file can be used to easily enter and execute a SQL statement and view the results in an HTML table.
• Instructions
  1. Open the sqlfun.asp file in the source code editor.
  2. Locate the line: querystring = " "
  3. Insert a complete SELECT between the quotation marks statement to return all the columns in the CustTable.
  4. To execute the statement, first save the file, then right-click the source editor window and select View in Browser. The statement will be executed and the output displayed in the browser window.
• Hints: If you have not inserted the sqlfun.asp file into the VirtualBookShelf.com project, refer to Lesson titled "Data binding" in the previous Module. The * character makes it very easy to request all the columns in a row. Of course, you can specify all the columns by name, but this is a lot easie