title: How to insert 1000 rows at a time
body: <p>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.</p>
  
  <p><code>Insert into db(@names,@email,@password) Values('abc','def','mypassword');</code></p>
  
  <p><em>I am using Sql-Server 2012 and ADO.net Connectivity! I want to execute this query in database to generate 1000 rows</em></p>
  
  <p><strong>EDIT</strong></p>
  
  <p><strong>What if i want to insert unique names?</strong></p>