BI Studio Query editor is a powerful SQL and 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
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.
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
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 query:
· Type: Result type.
· Description: SQL command and database engine message.
· Time: Execution time of the SQL command in milliseconds.
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.
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.