Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
crosscourt
Starting Member
1 Post |
 Posted - 2004-10-21 : 02:45:55
|
| string bulkInsertSQL = "BULK INSERT Table FROM '" + dateFilePath + "' " +"WITH (FORMATFILE='" + formatFilePath;...SqlCommand sqlCommand = conn.CreateCommand();SqlCommand.CommandText = bulkInsertSQL;int inserted = sqlCommand.ExecuteNonQuery();...I am inserting 2000 records and running the same sql gives 2000 rows affected."inserted" gets the value 4000 instead of 2000.Whats the reason behind that?thanks |
|
|
|
|
|
Bulk Insert from ADO returns double rows affected