Insert 2 million rows into SQL Server quickly
I have to insert about 2 million rows from a text file. And with inserting I have to create some master tables. What is the best and fast way to insert such a large set of data into SQL Server?
Tag: ado.net
How to test if a DataSet is empty?
I’m modifying someone else’s code where a query is performed using the following: DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(sqlString, sqlConn); da.Fill(ds); How can I tell …