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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-03-15 : 09:59:44
|
| Veronica PWP writes "Dear Sir/Madam,Re: Import image into a Field which with Data Type - Image-----------------------------------------------------------I have a field call FChapterCapture within the table tbl_Chapter.This field contain IMAGE data typeCould you please give some comment / solution for me, 1) How to enter a image into a field, which with IMAGE data type ?2) Is it possible for me to store more than 2000 image file into one table ? Will this slow down the whole processing of data retrieval ?I hope you can give me solution as soon as possible. Thank you.Happy Working !!!Ver" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-15 : 11:29:15
|
| The SQL Team FAQ:http://www.sqlteam.com/FAQ.aspHas a link that describes how to do this. However, it also recommends that you DON'T store images in a SQL Server database. Instead, the image itself should be kept as a regular file, and your SQL tables should contain a link to that file (the path and file name). There are NO benefits to storing the image in SQL Server, and numerous problems in doing so. Since performance is a concern for you, you should NOT store the images in the database. Storing and retrieving them will be much slower than if they were regular files (not to mention modifying images; this is FAR easier if they are files) |
 |
|
|
|
|
|
Import image into a Field which with Data Type - Image