Viewing SQL Data using dbForge Query Builder for SQL Server

Learn how to sort, filter, group table data, and how to use data editing tools of SQL Query Builder by Devart. More: https://www.devart.com/dbforge/sql/querybuilder/

Watch the latest video about Viewing SQL Data using dbForge Query Builder - https://www.youtube.com/watch?v=HbBxbFzgSXU&list=PLpO6-HKL9JxXSZgO3L0MxOTt3QxpFbJNt&index=14&

#SQLQuery #QueryBuilder #SQLServer #SQL

---

Closed Caption:

Welcome to dbForge Query Builder for SQL
Server Tutorials.
Learn how to sort, filter, group table data and
how to use key features of Data Editor.
First, we will show three ways to retrieve data.
You can click the corresponding option on the
shortcut menu of a table or view.
The second way to retrieve data is to click
"Generate Script As Select" on the shortcut
menu.
SQL document with the corresponding query
opens.
The result of the query execution is outputted in
Data View of the document.
Finally, here is the third way to retrieve data.
Click "New SQL" on the Standard toolbar.
Then, drag the required table and drop it on the
blank area of the document,
and execute the query.
As you see, the result data is outputted in Data
View.
Now let's take a look at data of the Employee
table.
Click Visible Columns on the shortcut menu.
This option allows to filter data by including or
excluding certain columns.
Lets exclude certain fields from the view for a
better data analysis.
Next, let's consider the Paginal Mode feature in
the context of the given table.
The table includes more than 1000 records,
thats why it was split into several pages.
Switch to the next page.
As you see, there is another 1000 records on
the page.
Now, let's switch to the next page, and change
the current setting to 100 records per page.
Navigate through the pages. As you see, now it
shows only 100 records per page.
Disable Paginal Mode, and navigate through the
records.
If you try navigating to the last record, the 'Out of
Memory' waring may appear.
Now, let's retrieve data from the view.
Data Editor can output data in two
modes - Table View and Card View.
Switch to Card View.
Click the Customize button to select visible
columns and set sorting and filtering for each
column.
Let's return to Table view to look at Data Editor
possibilities.
With Data Editor, you can sort column data in
ascending or descending order.
To filter data, click the Filter button on a column
header.
Or in Filter Editor, select a relation type and
then enter the required values.
Filters are saved in the list and can be used over
again.
Also, the Quick Filter list is generated for each
cell.
One more feature we'd like to cover is the Group
By Box.
Drag some column headers to the Group By
Box
and look at the result.
To quickly customize the view, you can select
the best fit option as well as to expand,
collapse, sort, and hide the columns.
Next, let's take a look at Data Viewer and
Editor.
To open it, click the option on the shortcut
menu, or double-click a column.
Data Viewer and Editor allows to quickly load,
edit and review data in hex, text, xml, rtf and
image views.
Data Editor also allows to print, export, copy
data with header or without it and much more.
Moreover, Data Editor includes a bunch of
options for customizing modes, colors, printing
and data formatting.
You can download dbForge Query Builder for
SQL Server at devart.com web site.
Thank you for watching.