---
title: "How to insert 10000 Data at a time in Sqlserver"  
description: "How to insert 10000 Data at a time in Sqlserver"  
author: "Anonymous User"  
published: 2016-01-01  
updated: 2016-01-01  
canonical: https://www.mindstick.com/forum/33820/how-to-insert-10000-data-at-a-time-in-sqlserver  
category: "database"  
tags: ["sql server", "sql", "sql server 2008", "sql server 2012"]  
reading_time: 1 minute  

---

# How to insert 10000 Data at a time in Sqlserver

I want to [insert](https://www.mindstick.com/blog/173/executing-insert-delete-or-update-query-in-sqlserver-using-ado-dot-net) 10000 [Data](https://www.mindstick.com/articles/13050/salesforce-aiming-to-dominate-predictive-analytics-with-data-science) at a time in [SqlServer](https://www.mindstick.com/forum/33737/between-condition-in-sqlserver) .please help me how to write query.

## Replies

### Reply by Anonymous User

**Step -1**we create a table as a customer name\

```
create table Customer
(
Cust_Id bigint primary key,
Cust_Name varchar(200),
Cust_ContactNo varchar(20)
)
```

**Step-2**write query for insert statement using while loop\

```
declare @Cust_id int;
select @Cust_id = 1;
while @Cust_id >=1 and @Cust_id <= 10000
begin
    insert into Customer values(@Cust_id,'Suresh' + convert(varchar(5), @Cust_id), '89532494**')
    select @Cust_id = @Cust_id + 1
end
```

**Step-3**Write select statement query to see result\

```
select* from Customer
```

YOUR RESULT WILL BE 10000 ROWS DATA LIKE BELOW**\****OUT PUT****\**\
![How to insert 10000 Data at a time in Sqlserver](https://www.mindstick.com/mindstickforums/b6b9a7ea-b2af-4104-a093-39360772842c/images/ea89451e-1297-4b91-9b64-820fa41b9997.png)\


---

Original Source: https://www.mindstick.com/forum/33820/how-to-insert-10000-data-at-a-time-in-sqlserver

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