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

18 votes189 views4 answers
Foreign key mySql
SQL
1 vote215 views1 answer
Postgresql round double precision
SQL
0 vote263 views1 answer
Generate random & unique mysql string
SQL
0 vote195 views2 answers
Laravel: customize or extend notifications - database model
SQL
4 votes235 views2 answers
Insert current date in mysql
SQL
5 votes234 views1 answer
Ascending order and where in sql
SQL
0 vote216 views1 answer
Set classpath for mysql-connector.jar
SQL
0 vote200 views2 answers
Sql regex vowel
SQL
1 vote187 views2 answers
Drop function in sql
SQL
0 vote200 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL