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...
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...
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...
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...
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 ...
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...