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

10 votes281 views1 answer
Oracle dba_dependencies
SQL
0 vote259 views1 answer
Alter precision
SQL
0 vote286 views1 answer
How to know if table in rigt or left in sql
SQL
4 votes226 views3 answers
Create table if not exists postgresql
SQL
0 vote278 views2 answers
Dbms interview questions
SQL
0 vote274 views1 answer
Declare date variable sql
SQL
7 votes294 views5 answers
Oracle alter table
SQL
0 vote270 views1 answer
Tsql generate rows
SQL
0 vote253 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
0 vote285 views1 answer
Oarcale list objects
SQL