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 vote122 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
2 votes115 views1 answer
How to add where command in update comand with joins
SQL
12 votes114 views3 answers
Install sqlite driver ubuntu
SQL
2 votes129 views1 answer
Create delete procedure mysql
SQL
0 vote120 views1 answer
Snap craft
SQL
0 vote118 views1 answer
Select in select sql
SQL
4 votes145 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
6 votes123 views2 answers
Stored procedure to delete data from table in mysql
SQL
3 votes122 views1 answer
Oracle undo tablespace list by user
SQL
0 vote116 views1 answer
Mssql current date
SQL