Results 1 to 5 of 5

Thread: bcp out text

  1. #1
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Unanswered: bcp out text

    what happens to text columns when they get bcp'ed out?

    Truncated to 8000?

    Going csv

    The project from hell...the "developer" knew access...thought text was Access text...painful...

    I'll be finding out soon I guess...any comments (sympathy) appreciated...

    Cross post!
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    No - you will be ok.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Well, I'll be doing it today...let you know what happens...

    REQ:

    Search every column in every table...find reference to keyword "x", then dump those rows out...

    painful
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    My Sympathies ....

    But tell me .. how did this requirement crop up ...
    would love to hear the story behind this one

    BTW ... am working on converting some ABAP code into stored procs ... and believe me ... i am forced to use cursors
    Last edited by Enigma; 12-04-03 at 10:44.
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  5. #5
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Inheritance....like I got the app to support and it's a piece of garbage...

    Someone knew Access, and things got out of control...

    Isn't that always the case?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •