SQL BULK INSERT

Simple Bulk insert TSQL csv

BULK 
INSERT 

[SALES].[Flowers]
        FROM 'C:\x\Learning\SQLServer2008DatabaseDev\FlowersData.csv'
            WITH
    (
                FIELDTERMINATOR = ',',
                ROWTERMINATOR = '\n'
    )
GO

SQL BULK INSERT

 public static void SqlBulkCopy(SqlConnection connection, DataTable table, string destinationTable)
        {
            connection.Open();

            try
            {
                var sqlBulkCopy = new SqlBulkCopy(connection);
                sqlBulkCopy.DestinationTableName = destinationTable;

                foreach (DataColumn column in table.Columns)
                {
                    sqlBulkCopy.ColumnMappings.Add(column.ColumnName, column.ColumnName);

                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                connection.Close();
            }
        }

Similar codes

49 votes379 views6 answers
Mysql add column to table
SQL
1 vote295 views1 answer
Mysql random limit 1
SQL
0 vote290 views1 answer
Sql select column names starting with
SQL
0 vote377 views1 answer
Plpgsql create function
SQL
0 vote300 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote306 views1 answer
Mysql start of today
SQL
-2 votes320 views4 answers
How to get max salary in each department in sql
SQL
0 vote317 views1 answer
Raiserror with nowait
SQL
0 vote294 views1 answer
Add sqlite3 in lumen
SQL
0 vote328 views1 answer
Shows all databases created by user in ms sql
SQL