zzz projects SqlBulkCopy Tutorial
Documentation Troubleshooting
Knowledge Base
  • Documentation
  • Troubleshooting
  • Knowledge Base

SqlBulkCopy Tutorial - Knowledge Base (KB)

6 results in tag: bulk

How do I retrieve the main keys of rows entered using a bulk copy from in PostgreSQL?

The goal is this: I have a set of values to go into table ...A..., and a set of values to go into table ...B.... The values going into ...B... reference values in ...A... (via a foreign key), so after inserting the ...A... values I need to know how to ref...
bulk performance postgresql sql sqlbulkcopy
asked by Claudiu

how to bcp out from sybase few columns from a table with many columns? Also can some logic be accommodated while retrieving data?

I have a huge table with 60 + columns in Sybase ASE, I want to bcp out 12 columns. I was checking syntax on ...manuals... but could not find a way to mention column names. ...I would also like to put some logic while retrieving data, like:...convt = case...
bcp bulk sqlbulkcopy sybase-ase
asked by Pritesh

SQL Bulk copy (unicode)

i have a problem with bulk load into my database. Server throws error "String or binary data would be truncated", but my data seems to be ok....Im using UTF-16LE data file with XML format file. Thanks for your answers...Here's my format file:...<BCPFORMA...
bulk bulkinsert sql sqlbulkcopy
asked by user2678896

BULK generate data SQL Server

I need to create fake data into ...fakeData... table that follows this psuedocode:...foreach(t1.id in table1) foreach(t2.id in table2) foreach(t3.id in table3) INSERT INTO fakeData (t1.id, t2.id, t3.id, random(30,80)) ...Where the id is t...
bulk bulkinsert sqlbulkcopy sql-server
asked by LearningJrDev

Skip host file column in bcp format file Sybase

I have a csv texte file like this : ...SicID;PorID;FarId;Company;DecadeId;SocName;FarName A1;A2;A3;A4;A5;A6;A7 B1;B2;B3;B4;B5;B6;B7 C1;C2;C3;C4;C5;C6;C7 ...I want to use Bcp Sybase to import this file in my_table but only the SicID, PorID and SocName. So ...
bcp bulk sqlbulkcopy sybase sybase-ase
asked by user3820903

How to properly avoid insert duplicate rows in SQL Server data tables which don't have any PK?

I'm using ...SqlBulkCopy... class in C# to copy data from one SQL Server database to another in a fast way. The databases are in different servers and their datatables don't have any PK, so the process gets more complicated....The problem is that the quer...
bulk c# sql sqlbulkcopy sql-server
asked by AnnaB

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!