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

19 votes220 views6 answers
Sql server drop table if exists
SQL
0 vote209 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote266 views1 answer
Postgres docs /copy metacomand
SQL
0 vote345 views1 answer
Sql developer export connections
SQL
3 votes223 views3 answers
Start postgresql ubuntu
SQL
1 vote211 views3 answers
Sql server get week dates from week number
SQL
0 vote188 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
22 votes206 views6 answers
Create sql table
SQL
0 vote210 views1 answer
Inner joint
SQL
0 vote209 views2 answers
How to save result of sqlite query in a table
SQL