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.

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 query:

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.