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 - 2004-01-06 : 08:43:28
|
| Sam writes "I need to upload a set of files in a directory into a table where one of its column is of image datatype.This is to view those attachments thru PeopleSoft.I find articles which tell me abt pointers , but I have to store the files in the table. All the files are in a directory say C:\SamI need the syntax for this ...pls provide me a solutionbe it an insert statement or thru a DTS " |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2004-01-06 : 09:03:52
|
| okay, well mostly all the response you will get here will also suggest that you store the path to the file in the database, and not the file itself. Is there a specific reason why you must store the file itself in the database?-------Moo. :) |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-01-06 : 14:36:09
|
| If you absolutely insist on storing images in your database (and I would give this some serious analysis because it impacts a lot of things, not the least of which is the total network traffic on your system) then you'll need to do some reading in BOL (SQL Server Books Online) about image data types and the WRITETEXT command. You'll probably also get to learn all about TEXTPTRs.--------------------------------------------------------------Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url] |
|
|
|
|
|
|
how to upload file attachments into table ?