forum

Home / DeveloperSection / Forums / How to insert 10000 Data at a time in Sqlserver

Ask Question

How to insert 10000 Data at a time in Sqlserver

Anonymous User 1936 01-Jan-2016

I want to insert 10000 Data at a time in SqlServer .please help me how to write query.

sql server sql sql server 2008 sql server 2012

Updated on 01-Jan-2016

Anonymous User

I am a content writter !

Can you answer this question?

Answer

1 Answers

Anonymous User

01-Jan-2016

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

forum

How to insert 10000 Data at a time in Sqlserver

Anonymous User

1 Answers

Liked By