SQL

1. SQL Reading the Reports SQL reports look similar to the ones shown here.  SQL - stands for Structured Query Language. It is the language used to access Scalable SQL for Windows data. With SQL, you can query your database in a variety of ways, using English-like statements.  The first column of the report lists field names. The second column indicates field types. The third column indicates field lengths. The fourth and final column provides a description of the field contents. 

2. The Menu Bar The Menu bar is located at the top of the SQLScope screen. It begins with the word File and continues with Edit, View, Settings, Database, Run, Window, and Help. You use the menus to give instructions to the software. To use a menu, you point with your mouse at the menu option and click the left mouse button. A drop-down menu will appear. To select an option, highlight the item on the drop-down menu and press Enter. An ellipse after a menu item signifies additional options; if you select that menu item, a dialog box will appear.  • .To log in to SQLScope:  • .Open SQLScope. • .In the Database Name field, enter the name of the database you wish to open. • .Note: For these exercises, use a test database. • .Type Master in the User Name field. • .If a password has been assigned, enter the password in the Password field. SQLScope is the interface used to access and manipulate data stored in a Scalable SQL for Windows database. The following sections describe the interface.  Errors SQL consists of commands you type into the SQLScope text box. If you receive an error message after entering a SQL command, check your spelling and syntax.

3. Importing Data You can import data into SQLScope from another data source by using the Insert command. Before completing the following exercises, you must import data into the tables you created. The example given in this section will step you through the process. Retrieving(ИЗВЛЕЧЕНИЕ)All Data Select statements are used to retrieve data from  SQL tables. The Select statement illustrated below retrieves all of the columns and rows  from the named table. Retrieving a Single Column You can use SQL to retrieve a single column of data. Retrieving Multiple Columns You can use SQL to retrieve multiple columns. Formatting Numbers By default, Scalable SQL displays numbers using scientific notation. To change the format, you must add a mask. Ordering Rows Data is stored in Scalable SQL in no particular sequence. If you want to see your data displayed in sequence, you must add an Order By clause to your Select statement.

4. Ordering Multiple Columns When ordering your data, you can have multiple sort levels. For example, you can order your data by city and then by name within the city. Retrieving Specific Rows So far, you have been retrieving all of the rows in the table. You can, however, specify which rows you wish to retrieve. For example, you could retrieve only those vendors who are in Chicago. Joining Tables So far, you have worked exclusively with a single table -- the TrnVendor table. You might have noticed that each module within Solomon IV consists of several tables. Within the Accounts Payable module, you will find the following tables: APAdjust, APDoc, APHist, APRefNbr, APSetup, APTran, and Vendor. Each table contains specific information. At times, you might need to join two or more tables to retrieve the information you need. For example, if you look at the TrnAPDoc table, you will see that it contains the vendor ID; however, it does not contain the vendor name. If, when retrieving information from the APDoc table, you want to see the vendor name, you have to join the TrnVendor table to the TrnAPDoc table.