14     Query Editor

BI Studio Query editor is a powerful SQL and MongoDB (JSON) editor and provides SQL and JSON code highlighting; IntelliSense (Code Completion), code regions, snippets and find features. It also displays the current executed query status with a progress bar and gives information about the total executed query status on the toolbar.

 

BI Studio provides powerful tools which allow you to edit query text directly with syntax highlighting and code completion.

 

SQL Query Editor

14.1                Executing a script

Pressing F5, CTRL+E or using the tool menu would execute any highlighted text in the query window. If no text is highlighted, all the text will be sent for execution.

14.2                Output Window

Many database servers such as Microsoft SQL Server are able to handle batch statements. This means they are able to execute many SQL statements at once, returning many data tables* (in case of select statements). If you are executing a script containing five select statements, the result would be five data tables presented in the output window.

Some other database servers, such as Oracle and MySQL, require each statement to end with a semicolon “;” and do not support batch statements. If you would type five statements (ended with “;”) in one script and execute it, BI Studio would split the script into five statements and execute each one separate from the others.
Using the “GO” word in MS SQL Server would give the same result.

 

When you execute a script that returns a result, the result of the script will be presented in the output window. The output window contains a Log output tab and tabs for each select query result. If there is more than one SQL select query all the results will be displayed here.

 

The Log window contains the following information about the SQL/Json command:

·         Type: Result type.

·         Info: Query Info

·         Description: SQL command and database engine message.

·         Time: Execution time of the SQL command in milliseconds.

 

14.3                IntelliSense

By pressing any key IntelliSense will provide an array of options that make language references easily accessible. When coding, you do not need to leave the editor window to perform searches on database elements.

 

You can keep your context, find the information you need, insert elements directly, and even have IntelliSense complete your typing. IntelliSense comprises database objects, reserved words, local variables, columns and even joining options.

 

14.4                Code Scripts

BI Studio’s IntelliSense snippets enable developers to easily manage and distribute their own customized SQL code libraries. Inserting these commonly used pieces of code is an effective way to enhance your productivity. You can save time because you no longer need to search countless sources of code examples just to find a similar piece of code to copy and paste into your solution code.

 

To add a snippet, simply highlight its text, right-click and select Snippets->Add to snippets. To delete a snippet, use the Snippet Manager on the toolbar.