Lab Sql

All I am using BCP for import export and getting 'Invalid character value for cast specificati… Read more Bcp Import Error "invalid Character Value For Cast Specification"

I'm using SQLBulkCopy, in pseudocode I do this: make new Employee datatable make new Employee… Read more How Do I Bulk Insert Two Datatables That Have An Identity Relationship

I am trying to find out how I can improve my insert performance in a temporary table in SQL Server … Read more Fastest Way To Insert 30 Thousand Rows In A Temp Table On Sql Server With C#

I got this following scenario, There are four tables COUNTRY, STATE, CITY, STREET And I have the ex… Read more Looping In Trigger?

I have a situation where I am importing many rows of data from text files. The import process occur… Read more Ordering In Sql Server

I have quite a few datatable to bulkinsert into databasetable Due to large size, one table took 5 m… Read more Async For Bulk Copy

I am reading data from an access db and storing it in a temporary sql table then truncate the main … Read more Date Must Be Between 1/1/1753 12:00:00 Am And 12/31/9999 11:59:59 Pm Overflow Error Sqlbulkcopy

I am evaluating different methods for inserting large amount of data in SQL server. I've found … Read more Inserting Bulk Data In Sql: Oledb Irowsetfastload Vs. Ado.net Sqlbulkcopy