SQL Queries

SQL

SQL (Structured Query Language) is a simple to use and learn programming language used by many database engines on many differing types of operating system platforms.

SQL commands can be used to modify a database's structure, query the database for information, or update the contents of your database. This powerful feature provides virtually unlimited access to your data, in the way you wish to see and use it.

Temps Plus JKM Help includes several useful examples which may be copied and pasted directly without having to learn any SQL language.

Reports

The results of any SQL Query can be not only viewed and edited, but printed directly from the SQL screen, without having to learn or use a report writer.

Mini-Applications

SQL is so powerful, a small but complete application can be created with two or three queries. For example, the "Outstanding Check Manager" application in Temps Plus consists of just three SQL queries that are created and run directly from the Queries screen.

Editing Your Database

You may directly edit (with the proper security clearances) the information in your database. Typical uses could be "search and replace" functions, adding fields to the tables in the database, or just about any database function you can think of.

Back