sqlbulkcopy
Select into statement where source is other database
How to copy data from one DB into another DB with the same table structure and keep the key identities?[详细]
2023-04-08 06:54 分类:问答writing xml data to sql server using sqlbulkcopy in C# asp.net
I have two xml files on m system called customers.xml and customerdetails.xml. I am attempting to write this data directly to an sql database I created in 开发者_运维技巧asp.net. All of my coding is i[详细]
2023-04-06 20:18 分类:问答Is it possible to use System.Transactions.TransactionScope with SqlBulkCopy?
Very simple question: is it possible to use System.Transactions.TransactionScope together with SqlBulkCopy? The documentation Transaction and Bulk Copy Operations doesn\'t mention anything (at least a[详细]
2023-04-02 09:17 分类:问答Getting SqlBulkCopy to honor column names
I\'m in the process of converting some stored procedure based reporting routines to run in C#.The general idea is to use all the wonders of C#/.NET Framework and then blast the results back into the D[详细]
2023-03-30 07:23 分类:问答SqlBulkCopy to upload Excel
If Im using SqlBulkCopy in .net 4.0 on a sql 2008 R2 da开发者_Python百科tabase to upload excel data to the database, do I actually need Excel on the box hosting the site for this to work?[详细]
2023-03-30 06:48 分类:问答SQL Server 2008 - To Insert/Update in Main table from Staging table
Once the开发者_高级运维 data is imported in a Staging table through Bulk Insert, then I need to do two steps:[详细]
2023-03-30 03:28 分类:问答SqlBulkCopy with Informix
Is there any way to use the SqlBulkCopy class with Informix database, or any al开发者_StackOverflow中文版ternative, because really I need this class behavior with my Informix database.[详细]
2023-03-28 15:45 分类:问答How can I copy DataTable contents to an SQL table while I'm filling it
I have defined a DataTable by adding typed columns. I expect the DataTable to range between 1 开发者_如何学Gomillion to 3 million rows.[详细]
2023-03-23 12:40 分类:问答SqlBulkCopy Insert with Identity Column
I am using the SqlBulkCopy object to insert a couple million generated rows into a database. The only problem is that the table I am inserting to has an identity column. I have tried setting the SqlBu[详细]
2023-03-19 04:33 分类:问答How to insert a constant value into a column using ASP.Net SqlBulkCopy
In the below code, I am trying insert the records from excel to Database table, but an additional column is not passed through the excel, which has to be populated with a constant value(foreach loop w[详细]
2023-03-17 11:19 分类:问答