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 vote161 views1 answer
Date diff sql
SQL
0 vote175 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
5 votes218 views1 answer
Dbms_metadata.get_ddl table
SQL
4 votes165 views2 answers
Mysql select where starts with
SQL
-1 vote166 views1 answer
Sql oracle take only last results
SQL
1 vote212 views1 answer
How to check all scheduled jobs in oracle
SQL
6 votes184 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
0 vote163 views1 answer
Create table sql generator
SQL
15 votes184 views6 answers
Laravel db transaction
SQL
2 votes155 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL