Advertisement
Advertisement
- 1. grant300 276,040
- 2. Joe_Woo... 130,290
- 3. bret 28,407
- 4. angelIII 12,742
- 5. LSMCons... 10,500
- 6. alpmoon 7,724
- 7. mark_wills 6,200
- 8. sdstuber 5,532
- 9. sandeep... 5,500
- 10. ee_rlee 4,500
- 11. IncisiveOne 4,304
- 12. diasroshan 4,180
- 13. Jan_Franek 4,022
- 14. thecodist 4,000
- 15. CEHJ 3,760
- 16. frankytee 3,000
- 16. mj_norwich 3,000
- 16. koppcha 3,000
- 19. hkamal 2,664
- 20. iziki 2,600
- 20. Limbeck 2,600
- 22. DanRollins 2,500
- 22. PeretzBen... 2,500
- 24. kolpdc 2,014
- 25. emoreau 2,000
- 25. simongv 2,000
- 25. Fernando... 2,000
- 25. silemone 2,000
- 25. mikesauce 2,000
- 25. Infinity08 2,000
- 25. aneeshatti... 2,000
- 25. nmcdermaid 2,000
- 25. borki 2,000
- 25. bcsql 2,000
- 25. jazzIIIlove 2,000
- 25. SnailGT 2,000
- 25. sentner 2,000
- 25. nedfine 2,000
- 25. ced888 2,000
- 25. BrandonG... 2,000
- 25. cmalakar 2,000
- 25. evilrix 2,000
- 25. Badotz 2,000
- 1. grant300 517,368
- 2. Joe_Woo... 439,157
- 3. bret 210,478
- 4. Jan_Franek 132,484
- 5. leonstryker 105,467
- 6. ChrisKing 73,084
- 7. alpmoon 72,058
- 8. namasi_n... 55,312
- 9. amitpagar... 40,464
- 10. angelIII 29,222
- 11. gletiecq 23,227
- 12. simongv 22,747
- 13. sybasetogo 20,552
- 14. koppcha 16,982
- 15. DaniPro 16,787
- 16. ahoor 15,235
- 17. david_lev... 14,146
- 18. Lowfatsp... 13,996
- 19. ajith_29 13,499
- 20. jkotek 13,383
- 21. hkamal 13,063
- 22. LSMCons... 11,500
- 23. knel1234 10,738
- 24. Acheton 9,457
- 25. naartjie 8,818
| 08.01.2008 at 07:47AM PDT, ID: 23614344 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
Hard Returns - Text Areas in table dump from Sybase to upload into SQL server
Asked by mahpog in Sybase Database, Microsoft Access Database, SQLBase
Tags: Sybase-Unix, SQL server, Hard returns - table dump from sybase using unix bcp to sql server load
I dump down to a text file using UNIX bcp, I am able to truncate my table and reload using Unix bcp to upload the downloaded table dump. I had to place a "marker" at the very end of my table definition in sybase so because the last two fields in my table are the last two textareas (SMC-Raytheon & SMC-Supplier). Otherwise any hard returns caused my bcp'd table dumps not to reload back up into the table.
I now have a request to send a table dump to Sql Server. Now they are having the original problem I had before adding a "marker" of "1" (defined as char in my table def). -See example1.bmp (used excel to show how record is wrapping and not staying on one line.
My goal is to do a full extract of my SQL table and being able to load it up into SQL server.
Do I need to code in a unicode hard return as the "marker" in my original sybase table def, or do I need to add a marker after each textarea defined????
Start Free Trial
