Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    Romania
    Posts
    70

    Unanswered: Easy question: Copy Image to a File

    How I can copy an image to a file?

    I want to use SP

    I use MSDE, textcopy is not installed

    I can use bcp, but I don't understand the syntax for image filed

    Something like this

    bcp "SELECT [ImageFiled] FROM MyDatabase..MYTable WHERE [ID]=1111" queryout c:\test.BMP -c -Sservername -Usa -Ppassword

    This statement don’t work.
    Please I need an example.


    Thanks,
    Sorry for my English

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578

Posting Permissions

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