INSERT 2000 records into SQL Database all at a time from C# .NET code

Posted by padmavathi on Stack Overflow See other posts from Stack Overflow or by padmavathi
Published on 2010-04-23T15:09:52Z Indexed on 2010/04/23 15:13 UTC
Read the original article Hit count: 128

Filed under:

We need to INSERT 2000 records into SQL DB from C# .Net code. For this is there any way to INSERT all 2000 records at a time instead of executing the INSERT query for each record. Also how would be the performance impact of doing this?

Thanks & Regards Padma

© Stack Overflow or respective owner

Related posts about sql-server