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 vote363 views1 answer
Ms sql print more than 1 variable
SQL
0 vote346 views1 answer
Can we rollback data that are deleted using DELETE
SQL
3 votes350 views1 answer
Mysql set field unique
SQL
2 votes399 views2 answers
Mysql on duplicate key update get value from values
SQL
0 vote348 views1 answer
Fetch second word from a string in ms sql
SQL
0 vote351 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote355 views2 answers
Create sequence if not exists postgres
SQL
0 vote376 views1 answer
Mysql user set plugin
SQL
0 vote351 views1 answer
Restart sql server command line linux
SQL
8 votes342 views1 answer
Unique vs primary key
SQL