You can make ad hoc queries on any tables in the database. Ad hoc queries let you:
do more than you can do in WellSim
do what you can already do in WellSim, but do it faster.
This lets you you can change and delete parts of the database, which might delete some of your data or cause WellSim to crash.
Only use this if you know what you are doing.
Before you start, back up the database.
To query an SQL server database you must have Administrator permission.
From within WellSim, click
Tools in the menu bar, then click
Database Administration to display:
The left has a list of all tables in the currently-open database and the right is to type SQL queries.
After you have finished:
The formats for SQL queries for Access and SQL server differ slightly; these examples use the sample database, and so are for Access.
Here, table names are all capitals (WELL) and column names are first letters capital (Well).
Data in the database is in SI units.
Complex queries can take a long time to run.