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 vote182 views1 answer
Count number of entires by months sql
SQL
0 vote179 views1 answer
Mysql add comment to column
SQL
3 votes165 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
1 vote187 views1 answer
Create new table in SQL from old table with data
SQL
24 votes179 views5 answers
Sql server insert into select
SQL
0 vote134 views1 answer
Mysql insert with foreign key
SQL
0 vote213 views1 answer
SQL Where-Klausel
SQL
0 vote190 views1 answer
Ajax error exception handeling
SQL
7 votes169 views1 answer
Grant schema permissions postgres
SQL
1 vote198 views1 answer
Postgres see sequence current state
SQL