Selecting All Rows from a SQL Table

There are many times that you will want to select all rows from a given database table. How do you move through the records, and display the data?

Let’s say you have a table with BookName as a field and you want to write to the screen all BookNames in your library.

Selecting All Rows from a SQL Table