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 vote344 views1 answer
Postegresql update to null
SQL
0 vote326 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote320 views1 answer
T sql less than date
SQL
5 votes323 views1 answer
Oracle generate list of dates in between a date range
SQL
0 vote340 views1 answer
ERROR: column "hourly_visitors.hour" must appear in the GROUP BY clause or be used in an aggregate function
SQL
0 vote361 views1 answer
How to add mysql to path on termin after installation
SQL
1 vote322 views1 answer
How to select rows with no matching entry in another table?
SQL
5 votes379 views3 answers
Sql limit offset
SQL
2 votes349 views1 answer
Dbms transaction (psql)
SQL
0 vote339 views1 answer
How to add session data into mysql database from button
SQL