Bulk Insert/Update in MS SQL

This article explains how to insert/update bulk data in .net application. This way your application will improve performance. For example, inserting few hundred records together into same table, we normally do something like:For i AsInteger = 0 To 200'SQL insert/updateNext For insert, Luckily, .NET has a SqlBulkCopyClass that Lets you efficiently bulk load a SQL Server table with data from another source. Here, i will save datatable into sql table.Using bulkcopy As SqlBulkCopy = New SqlBulkCopy(Configur...