How to create SQL INSERT Statement using dbForge Query Builder for SQL Server

Quick and seamless data inserting into tables with the help of SQL INSERT statement designed with dbForge Query Builder for SQL Server.

In this video you'll learn how to:
🔹 create a SELECT query;
🔹 preview added data;
🔹 convert a SELECT query into an INSERT query and run it.

dbForge Query Builder is a graphical SQL query designer for dealing with SQL Server through a neat and intuitive UI.

Some of the main features include:
🔹 send to' command for quick sending of tables into Query Builder;
🔹 multi-selection for butch operations on numerous data objects;
🔹 the diagram with zooming;
🔹 quick conversion of SELECT query into INSERT query.

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

Download dbForge Query Builder for SQL Server here:
https://www.devart.com/dbforge/sql/querybuilder/download.html

#INSERT #SQLQuery #QueryBuilder #SQLServer #dbForge #Devart

---

Closed Caption:

Welcome to dbForge Query Builder for Sequel
Server Tutorials.
In this tutorial, you will learn how to:
create a SELECT query
preview added data,
convert a SELECT query to an INSERT query
and run it.
First, we will show how to insert data into
a table.
Select the Example.Customer table, and retrieve
data from it.
As you can see, there are no records in the
table at the moment.
Now, send the table to the Query Builder diagram.
Change the query type from "Select" to "Insert
values".
Select required columns,
assign values to them,
and execute the query.
Here is the result.
Let's take a look at the table data.
As you can see, the data has been successfully
inserted into the table.
This query allows adding user-defined column
values to the table.
However, it is not applicable when inserting
multiple data.
Therefore, let's consider inserting values
of several Source tables into a single target
table.
Select the necessary tables and send them
to the Query Builder.
Let's fit the diagram view for a better visual
experience.
Add a selection condition for the query.
Let's select all records from the AddressType
table and filter them by the "Name" column
with the condition “Values is equal "Home".
Now select the columns that you want to insert
into the table.
You can preview the data that will be inserted.
You can see, there is a lot of data that matches
the condition.
Change the query type from "Select" to "Insert
results".
Next, select the table to insert data into,
and ensure that the table and query fields
match.
In this case, they don't, since the field
order in the table differs from that in the
query.
Let's fix that.
Note, that the column types must match as
well, while matching Column names are not
obligatory.
Let's take a look at the query text.
Everything is fine.
Now, execute the query and ensure that the
data has been inserted successfully.
Here is our result.
Everything is just as designed.
You have been watching a dbForge Query Builder
for Sequel Server Tutorial.
You can download the tool at devart.com.
Thank you for your attention.