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 vote172 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote176 views2 answers
Sql having multiple conditions
SQL
0 vote206 views2 answers
Sql if empty then
SQL
1 vote199 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
0 vote186 views2 answers
Close external port 3306 with iptables
SQL
0 vote212 views1 answer
Mysql query to select the highest value
SQL
2 votes181 views1 answer
Q operator in plsql
SQL
1 vote187 views2 answers
Foreign key set 0
SQL
0 vote170 views1 answer
SQL server select to get sum of hours
SQL
0 vote197 views1 answer
Learnxinyminutes sql
SQL