Saturday, 31 August 2013

How to insert 1000 rows at a time

How to insert 1000 rows at a time

I made Wpf appliaction. I want to test it with 1000 values in grid. I want
to check that whether my grid will load 1000 data records fastly or not.
So how to write one query to insert more than 1000 records in my database
table. can i use for loop.
Insert into db(@names,@email,@password) Values('abc','def','mypassword');
I am using Sql-Server 2012 and ADO.net Connectivity! I want to execute
this query in database to generate 1000 rows

No comments:

Post a Comment