How to operate with data effortlessly with dbForge SQL Complete

Check our new video about how SQL Complete can simplify your work with SQL Server data. This video tutorial shows you how this tool helps developers search, copy, and visualize data represented in the SSMS results grid.

dbForge SQL Complete is designed to help calculate sums and average values in the received data sets. This is far quicker and simpler than using spreadsheets for the same purpose. Use this powerful and handy IDE for generating scripts directly from the results grid. It is also very easy to copy data from a cell or an entire table in the results grid to clipboard or to CSV, XML, HTML, and JSON files.

In this tutorial, we will show you how to work more effectively and productively!

Timestamps:
0:00 Introduction
0:07 How to display data in a human-readable format and save it to a file
0:27 Calculating aggregates data
0:48 How to quick search data in the results grid
0:57 How to copy results data to a file or clipboard in the different formats
1:24 Generating SQL query from the results grid

Do you have any questions or ideas about our tutorials? Feel free to write about it in the comment section!

👉 Do you want to know more information about dbForge SQL Complete? Watch our overview video: https://youtu.be/0kaPoEINMSM

✅ Check a full list of dbForge SQL Complete features:
https://www.devart.com/dbforge/sql/sqlcomplete/features.html

🔥 Download a 14-day free trial version of dbForge SQL Complete:
https://www.devart.com/dbforge/sql/sqlcomplete/download.html

🔔 Subscribe to our channel and get dozens of tutorials about Devart tools:
https://www.youtube.com/c/DevartSoftware

#SQLServer #SQLServerTutorial #SQLServerTools #DatabaseTools #ToolsForDevelopers #SQLTipsAndTricks

---

Closed Caption:

SQL Complete comes with an advanced Data Viewer
that helps visualize data output to the SSMS
results grid.
The Data Viewer allows you to easily display
XML data in a human-readable format, view
the formatted JSON data, graphically display
spatial data, and much more.
In addition, from the Data Viewer, you can
copy data to the clipboard and then save it
to a file.
The Aggregate Panel of SQL Complete allows
you to instantly calculate aggregates.
The Panel automatically displays the aggregate
values for columns at the bottom of the SSMS
results grid.
Just select a range of values in the results
grid, and the aggregate panel will automatically
show the aggregates for the selected range.
You can also easily copy the selected values
to the clipboard.
SQL Complete also boasts robust search functionality.
With it, you can quickly locate the data you
need in the results grid.
With SQL Complete, you can easily copy data
from the Results Grid to a file or clipboard
in the CSV, XML, HTML, and JSON formats.
To copy data from the Results Grid, select
the values you want to copy, right-click the
selection, click Copy Data As and then select
the format you want the data to be copied
in.
It is also worth noting that for the CSV format,
rich customization options are provided.
SQL Complete can help you turn the query results
into code that you can use in another query.
Just highlight the required values in the
results grid and then select how the values
should be scripted - as INSERT, WHERE IN,
WHERE AND OR, or UPDATE.
To discover the full potential of the tool,
download SQL Complete from devart.com or schedule
a personalized demo with the dbForge Account
Executive.