How to insert 10000 Data at a time in Sqlserver

Question

Anonymous User · Answer

Step -1we create a table as a customer namecreate table Customer
(
Cust_Id bigint primary key,
Cust_Name varchar(200),
Cust_ContactNo varchar(20)
)Step-2write query for insert statement using while loopdeclare @Cust_id int; 
select @Cust_id = 1;
while @Cust_id andgt;=1 and @Cust_id andlt;= 10000
begin
    insert into Customer values(@Cust_id,'Suresh' + convert(varchar(5), @Cust_id), '89532494**')
    select @Cust_id = @Cust_id + 1
endStep-3Write select statement query to see resultselect* from CustomerYOUR RESULT WILL BE 10000 ROWS DATA LIKE BELOWOUT PUT

forum

How to insert 10000 Data at a time in Sqlserver

Anonymous User

Can you answer this question?

1 Answers

Liked By