Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    60

    Unanswered: Text field copying

    I am working with a homecare application that stores nursing notes into a text field in the database. The database is growing exponentially and I want to create a procedure that select all notes older than six months, write it to an OS file, then deletes the record in the database. I am doing the writing using a cursor, however this is very slow.

    Has anyone done anything similar? Let me know..

    Thanks
    jaraba

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    You can use TEXTCOPY commandline utility. It was not easy to dig it out since it does not come with SQL2K.

    Check this link:

    http://www.codeproject.com/dotnet/ScriptDatabase.asp
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Sweet ... I put that link in my toolbox.

Posting Permissions

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