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

0 vote147 views1 answer
Set classpath for mysql-connector.jar
SQL
1 vote117 views1 answer
Mysql Case sum
SQL
1 vote112 views1 answer
Get table column names sql ssms
SQL
0 vote113 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
0 vote113 views1 answer
Xampp increame mysql speed
SQL
1 vote123 views2 answers
Sql server concat string and int
SQL
11 votes115 views1 answer
Mysql text type max length
SQL
33 votes106 views2 answers
Postgres how to add field created at
SQL
0 vote115 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
1 vote69 views1 answer
Enable mysql slow query log
SQL