Editing SQL Data using dbForge Query Builder for SQL Server

⚡️ See how to manipulate SQL Server table data using dbForge Query Builder for SQL Server

📋 In this tutorial, we are going to learn how to:
📍 Edit data with the foreign key look up functionality
📍 Insert, update, delete and export data

🔗 Find more information about dbForge Query Builder here:
https://www.devart.com/dbforge/sql/querybuilder/

🔥 For downloading a trial version visit:
https://www.devart.com/dbforge/sql/querybuilder/download.html

---

Closed Caption:

Welcome to dbForge Query Builder for Sequel
Server Tutorials.
In this tutorial, we are going to learn how
to:
Edit data with the foreign key look up functionality
Insert, update, delete and export data.
Retrieve data from the table.
Append a new row to it.
We will use the Foreign Key Lookup feature
to save data consistency and speed up the input
With the Date editor, you can quickly set
a new date or modify the current one.
After editing, you can apply changes by clicking
"End Edit" or roll back modifications by clicking "Cancel Edit"
Let's select "End Edit"
As you can see, the data was added successfully.
Let's delete a few records and apply this
command.
To simplify the data recovery process, we
can present the table data either fully or
partially as a script with insert commands.
You can see the script in the Sequel Document.
It is also possible to export data to many
popular formats.
As an example, let's export data to the MS
Excel format.
Data Export Wizard includes a wide range of
options to customize your export operation.
Data Export was performed successfully.
Let's use the StoreWithDemographics view.
We can modify field values of the tables it
contains.
This was a brief overview of Query Builder
Data Editor functionality.
Download a 30 day trial edition of dbForge
Query Builder at devart.com.
Thank you for watching.