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 |
|
gercr
Yak Posting Veteran
53 Posts |
 Posted - 2003-11-26 : 17:14:15
|
| Hi all, maybe someone already ask this, but I need to insert a image into a table, the field datatype is image.Is this insert ok?insert into testimg (num_img,img)Values (1,'c:\testimg\imagentest.gif') |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2003-11-27 : 05:28:46
|
| The best advice given around here....(and it's a quiet day, due to USA Thanksgiving)....is not to store images/blobs in SQL, but to leave them on a lan drive accessible by the SQL Service....and to just store the 'file-path' in the SQL table.search for SQL + images/pictures/blob...and you'll be able to read about others experiences. |
 |
|
|
|
|
|
Insert a Image