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