---
title: "Insert Multiple Rows into Single Table"  
description: "Here we describe how to insert records into table in multiple ways. Currently when developers have to insert any value into the table they have to wri"  
author: "AVADHESH PATEL"  
published: 2012-11-01  
updated: 2014-09-18  
canonical: https://www.mindstick.com/blog/385/insert-multiple-rows-into-single-table  
category: "database"  
tags: ["database"]  
reading_time: 1 minute  

---

# Insert Multiple Rows into Single Table

Here we [describe](https://www.mindstick.com/interview/12752/what-is-ddms-describe-some-of-its-capabilities) how to insert [records](https://www.mindstick.com/forum/34640/how-to-create-a-stored-procedure-for-display-all-records) into table in multiple ways. Currently when [developers](https://www.mindstick.com/blog/302688/handling-errors-in-rust-a-comprehensive-guide-for-developers) have to insert any value into the table they have to write multiple insert statements. First of all this is not only boring it is also very much time consuming as well. Additionally, one has to repeat the same syntax so many times that the word boring becomes an understatement.\

We have demonstrated three different [methods](https://www.mindstick.com/articles/13060/runny-nose-remedy-methods-that-work-best) to [insert multiple](https://www.mindstick.com/forum/399/how-to-insert-multiple-values-selected-in-checkbox-in-database) values into a [single table](https://www.mindstick.com/forum/161031/how-to-grant-permission-to-user-on-a-single-table-in-sql-server).

For demonstration first we create a table.

```
-- SELECT DATABASE NAMEUSE <DATABASE NAME>-- CREATE TABLECREATE TABLE [dbo.Employee]([ID] INT PRIMARY KEY IDENTITY(1,1),[Name] VARCHAR(50)NOT NULL,[Designation] VARCHAR(50) NOT NULL)
```

Method 1: Traditional Method of INSERT…VALUE

```
--Traditional Method of INSERT…VALUEINSERT INTO [dbo.Employee] VALUES ('Jems','Developer');INSERT INTO [dbo.Employee] VALUES ('Karlosh','Designer');INSERT INTO [dbo.Employee] VALUES ('Garry','Marketing');INSERT INTO [dbo.Employee] VALUES ('Thomash','Helper');INSERT INTO [dbo.Employee] VALUES ('Alvert','Recruiter');
```

Method 2: INSERT…SELECT

```
-- Method 2 - Select Union InsertINSERT INTO [dbo.Employee] ([Name],[Designation])SELECT 'Jems','Developer'UNION ALLSELECT 'Karlosh','Designer'UNION ALLSELECT 'Garry','Marketing'UNION ALLSELECT 'Thomash','Helper'UNION ALLSELECT 'Alvert','Recruiter'
```

Method 3: [SQL Server](https://www.mindstick.com/articles/12999/what-is-table-valued-function-in-sql-server) 2008+ Row [Construction](https://www.mindstick.com/articles/167589/the-reasons-why-we-love-construction-jobs-salary)

```
-- Method 3 - SQL Server 2008+ Row ConstructionINSERT INTO [dbo.Employee] ([Name],[Designation]) VALUES ('Jems','Developer'), ('Karlosh','Designer'), ('Garry','Marketing'),('Thomash','Helper'),('Alvert','Recruiter')
```

---

Original Source: https://www.mindstick.com/blog/385/insert-multiple-rows-into-single-table

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.