The query source code feature enables an implementer or administrator to edit existing queries or create new ones. This is possible by directly entering Microsoft T-SQL code. The entire language range can be used with a few exceptions, e.g. parallel threads are not possible. A variable built into Interface Scan is @Period. It contains the value of the currently selected period.
Outputting Messages
If queries are executed, a result list is created. Using a PRINT statement, messages can also be created for the respective queries, which are output in the additional tab Messages:
Limitations:
- If multiple PRINT statements are used, only the last message is output.
- If a PRINT statement is used in a query that does not produce a result list, the information Error:<Print-Output> is output instead of the result list. However, the message is output correctly in the Messages tab.
Context Menu of the Query Source Code
| Entry | Description |
|---|---|
| Select all | Selects the entire text of the editor |
| Cut | Cuts the selected text and copies it to the clipboard |
| Copy | Copies the selected text to the clipboard |
| Paste | Pastes the text of the clipboard where the cursor is positioned |
| Undo | Undoes the last step |
| Redo | Undoes the last Undo step |
| Find | Opens the search field |
| Replace | Opens the search and replace field |
| Change Font | Opens the settings window to edit the font of the editor |
| Show line numbers | Shows the line numbers in the editor |
