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 vote261 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
0 vote226 views1 answer
Microsoft word insert sql code
SQL
-1 vote236 views1 answer
Sql add column bit
SQL
0 vote269 views1 answer
Site:av.ru "files"
SQL
9 votes228 views4 answers
How to remove duplicate in sql
SQL
0 vote229 views1 answer
The local psql command could not be located
SQL
0 vote235 views1 answer
Show size of all tables postgres
SQL
3 votes239 views2 answers
Mysql config user password
SQL
0 vote243 views1 answer
Find usage of table in sql server
SQL
0 vote243 views1 answer
Get who is hired in month in sql
SQL