Bulk inserting data into SQL Server

This page cannot be shown here. You can still read it on the original site — the toolbar below keeps your place in the directory.

Let’s say with have a simple table in SQL Server CREATE TABLE [ dbo ].[ test ]( [ Value ] [ varchar ]( 36 ) NOT NULL ) …in which we want to insert thousands of values (Guids) from a .NET application. One by one A naive approach is to insert one at a time, like this: public void OneByOne () { const string sql = "INSERT INTO [Test] ([Value]) Values (@Value)" ; for ( var i = 0 ; i < count ; i ++) {…

Read on /2017/11/28/sql-bulk-copy/ ↗