Designing SELECT Query using dbForge Query Builder for SQL Server

Learn how to design and select a query visually, wrap it into a subquery and navigate through a query using Document Outline.

Learn more: https://www.devart.com/dbforge/sql/querybuilder/

Watch the latest video about Designing SELECT Query using dbForge Query Builder: https://www.youtube.com/watch?v=aepK_RnVc04&list=PLpO6-HKL9JxXSZgO3L0MxOTt3QxpFbJNt&index=20

#Database #SQLQuery #QueryBuilder #SQLServer

---

Closed Caption:

Wellcome to Query Builder Tutorials.
In this tutorial we will learn how to:
- design and select a query visually,
- wrap it into a subquery,
- navigate through a query using Document
Outline.
You can open Query Builder using Start Page or
toolbar.
Your query will be displayed visually on the
diagram.
To use Query Builder, drag the required objects
from Database Explorer.
Joins were created automatically.
To view these joins, just double-click them.
By default, Query Builder is loaded in the
SELECT type.
But there are other types that you can switch
by using the popup menu.
To exclude columns that are not needed in the
selection, check only the ones that are required.
Selected columns are automatically displayed in
Tabbed Editor.
Let's execute the query and look at the data it
returned.
From the resulting data, let's select cities,
names of which begin with the letter "C".
To do this, let's open the WHERE tab and
create the corresponding condition.
As you see, filtering was applied successfully
and we received the requested data.
Let's change the query so that the cities, names
of which begin with the letter "C" are omitted in
the result.
As you can see code completion suggests
relevant keywords.
The changes are automatically displayed in the
WHERE tab and filter.
Data is received in correspondence with the
specified condition.
These two tables can be converted into a
subquery.
To do this, let's use the Wrap to subquery
functioanlity.
Now tables are transformed into a subquery.
Drag the required object from Database Explorer.
Let's select the required columns.
Now, let's join the table and the subquery by
"SalesTerritoryKey".
You can execute the root query -
for this, let's click "execute current statement"
when the "Root" tab is active.
And now you can execute the subquery.
To do this, let's click Execute current statement
when the Subquery tab is active.
You can view the query structure using the
Document Outline window.
In this case, you can see the subquery and the
root query.
Using Document Outline, you can easily
navigate though all query elements.
If you accidentally forgot to save the query and closed the appliaction or if the application crashed,
not a big deal - dbForge will autmoatically save your data.
Let's open the application,
and then open the restored tab.
As you see, the qurey has been succesfully restored.
You have been watching Query Builder Tutorial.
You can download dbForge Data Studio from
devart.com.
Thank you for watching.