Insert Records using SELECT and UNION ALL Statements in SQL

We have different ways to insert data in table. In this blog you will learn how to insert data using SELECT and UNION ALL statements.

 

The following script helps to create the table. 

Create table Mas_Employee(
   Id int primary key identity(1,1),
   Name varchar(50),
   Salary int ,
   DeptId int
)

Insert data into table using SELECT and Union 

insert into Mas_Employee ( Name, Salary, DeptId )
select 'Jaipal',18200,1     union all
select 'Jayanth',14200,2 union all
select 'Sreeshanth',12999,2 union all
select 'Tejaswini',16800,1

I hope you enjoyed it. Please provide your valuable suggestions and feedback if you found this article helpful.