sqlbulkcopy
OracleBulkCopy AutoCommits
C#.Net I am using OracleBulkCopy to copy data to global temp tables that are declared as Delete on commit. So when I use OracleBulkCopy.WriteToServer(Da开发者_StackOverflow社区taReader). It commits an[详细]
2023-02-16 20:46 分类:问答SQL Server: SqlBulkCopy import causes primary key violations
I am trying to design a window based application in C#.NET. I am reading csv file in data grid view and then insert those data into database. I am using SqlBulkCopy to insert data from csv file into d[详细]
2023-02-16 06:01 分类:问答SQLBulkCopy Throws InvalidOperationException Nullable Ints
I have a DataTable that I am attempting to 开发者_开发技巧upload, but I run into the following exception:[详细]
2023-02-13 10:57 分类:问答DBMS_SQL.Execute and BULK update - Need Help
I have this query select col1, col2 from table where critera = :criteria_var The particular query was being used in DBMS_SQL to open cursor and BIND the variables. The values are then being fetche[详细]
2023-02-12 19:44 分类:问答bulk copy duplicating each row when it is added to database
Why is my bulk copy duplicating each row, so in my database table the row shows twice. Label1.Visible = True[详细]
2023-02-12 11:47 分类:问答SqlBulkCopy calculated field
I am working on moving a database from MS Access to sql server. To move the data into the new tables I have decided to write a sync routine as the schema has changed quite significantly and it lets me[详细]
2023-02-11 05:42 分类:问答Fast inserts; BulkCopy with relational data
I have a large amount of constantly incoming data (roughly 10,000 a minute, and growing) that I want to insert into a database as efficiently as possible. At the moment I\'m using prepared insert stat[详细]
2023-02-10 21:40 分类:问答.net 4 sql bulk insert on 64bit iis 7
i need to import some bulk data in an asp.net application from txt/csv files until now i used SqlBulkCopy, but now on iis7 with 64bit it doesn\'t work. there are many posts about jet not working with[详细]
2023-02-10 04:15 分类:问答Cannot enable select into/bulkcopy on SQL Server 2005 database using sp_dboption
I am trying to enable the select into/bulkcopy database option on a SQL Server 2005 database using the command:[详细]
2023-02-09 12:57 分类:问答Oracle ODP.NET BulkCopy to temporary table issue
I\'m using BulkCopy method from ODP.NET to insert a DataTable to a temporary table. If the temporary table is simple (no triggers or indexes) it works, fine, but as soon as I create an index or trigge[详细]
2023-02-09 09:33 分类:问答