Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
dbarkley
Starting Member
1 Post |
Posted - 2012-10-12 : 11:33:38
|
I know your should not store pictures in a SQL table but I have a need to do this.Here is what I have. Col1 - part numberCol2 - Part DescriptionCol3 - Part Imagethe images are stored on a network location, lets says \\server1\images\partnumber.jpgHow can I update all of part images using (col1)partnumber in the network location?So if my part number in col1 is 12345 I want to go out to the network location \\server1\images\ and insert\update the col3 with the picture 12345.jpg.I am trying but I can not seem to find a way to do this.Any help would be great. |
|
Mike Jackson
Starting Member
37 Posts |
Posted - 2012-10-17 : 08:54:05
|
Why don't you just store the reference to the file in col3?Mike |
|
|
Ifor
Aged Yak Warrior
700 Posts |
|
|
|
|