Query Tab

Query tabs are used to run raw SQL queries on the database. Query tabs require Query Analyzer access. To open a new query tab select Query Analyzer tab then expand the database object in the tree and select New Query.


Toolbar

Runs the sql query entered into the query box
Inserts a template of a select statement into the query box
Inserts a template of an insert statement into the query box
Inserts a template of an update statement into the query box
Inserts a template of a delete statement into the query box
Will undo the last text edit in the query box short key Ctrl-Z
Will redo the last undo in the query box short key Ctrl-Y
Will save the query to file in my documents folder and is accessible in User queries in the Query Analyzer tree
Will show hide the Shift Selector (more) when visible {0} and {1} will be replaced in the query with start end end of shift link in the reports.

Results of a query are shown at the bottom. If a query fails an error message will be in the Messages tab. The query window supports the return of multiple result sets. The different tables returned can be selected from the dropdown list. Pressing the save button will allow the saving of the current selected grid to excel.

Query Execution Time As a query is executing this timer will be counting up. Once the query is completed this will show how long it took to excute


 
query_tab.txt ยท Last modified: 2015/11/25 08:38 (external edit)