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

2 votes151 views2 answers
Postgres drop column if exists
SQL
0 vote158 views1 answer
Sql ssrs
SQL
6 votes101 views2 answers
How to get yesterday date in mysql
SQL
1 vote110 views1 answer
Postgresql transaction discard all
SQL
0 vote89 views1 answer
Possgress drop if exists view
SQL
1 vote122 views1 answer
Postgres cast as currency format
SQL
6 votes111 views2 answers
Foreign key sqlite3 python
SQL
-1 vote165 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
0 vote107 views1 answer
Conda install pymysql "windows"
SQL
15 votes114 views4 answers
Pl sql
SQL