SQL query
The SQL query feature is a freeware function of the program. Any number of SQL queries and statements can be executed in this window.
A specialty of the program, that you can find a string in the results. Another specialty of the application, that the content of the results tables can be narrowed using various criteria.
The SQL statements can be executed using three SQL interpreters:
- Unchanged: the text (or the selected text in the case of a selection) in the SQL editor is sent to the SQL server in unchanged format.
- GO: The statements are broken in new lines with a "GO" statement. The program sends each part to the SQL server for validation.
The result of the SQL statement can be dumped using one of the two available methods: text or grid.
Screenshots:
|
Firstly, you have to select the database server |
|
|
The SQL query consists of two parts:
|
|
|
The results table can be copied in textual format. You can select the CSV and HTML formats as well. |
|
|
A specialty of the program, that you can find a string in the results. The search can be performed in a specified column, too. |
|
|
The result table can be sorted. |
|
|
The context menu of the SQL editor. |
|
|
The context menu of the Results pane. You can immediately edit the database tables. (The program will create the SQL statement to be executed by the entered information.) The powerful filtering feature is a big help in your work. |
|
|
Another specialty of the application, that the content of the results tables can be narrowed using various criteria. The table columns can be referred as well. 19 numerical functions, 20 strings, 10 dates and 10 aggregating functions can be used. |
|
|
The fields of the results table can be summarized. An expression can be compiled, too. |
|
Download
