Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

How to insert 10000 Data at a time in Sqlserver

Anonymous User 2338 01 Jan 2016

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

Anonymous User

Sr. Software Developer

I am a content writter !

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

advertising