Results 1 to 2 of 2

Thread: Putting images in an unpopulated table.

  1. 09-01-2005, 09:16 AM #1
    ColumbusWolf
    ColumbusWolf is offline Registered User
    Join Date
    Dec 2003
    Posts
    43

    Putting images in an unpopulated table.

    Here's what I've got.

    We have a table that needs to be populated with a Foreign Key and an image file that matches it. The image file is named the the person's SSN which matches the FK.

    Is there a way I can use the name of the file (123456789.jpg) to import it into the database or is there a better way?
    Reply With Quote Reply With Quote
  2. 09-01-2005, 10:39 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You have to use UPDATETEXT command to load the image in the database or you may use TEXTCOPY utility (found in C:\Program Files\Microsoft SQL Server\80\Tools\Devtools\Samples\DBLib\TextCopy)

    But you can't use image data as foreign key column, you should have a separate column for that.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules