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 |
|
dwfresh
Starting Member
4 Posts |
 Posted - 2003-05-06 : 14:14:04
|
| Hi, I am trying to set a column in my SQL Server DB to be a 'pointer' to an image file.I have had no luck finding any resources on the web, except those that actually store the image in the DB, which is not what I want.Can anyone tell me exactly how to do this?What do I set as the datatype for this column?Also, is it the same process of setting a pointer to a text file?I'm a rookie DB person so please excuse my ignorant questions!!Thanks!! |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-06 : 14:45:01
|
| Not really sure, but I think all you want to store is the path and filename of anything on your box or someplace else on your network...using unc file names Is that what you're talking about?Brett8-) |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-06 : 14:55:22
|
| A pointer? What you want is the path to the file as X002548 mentioned. So it doesn't matter what kind of file it is, just store the path in the database. The datatype would be varchar.Tara |
|
|
|
dwfresh
Starting Member
4 Posts |
Posted - 2003-05-06 : 21:03:18
|
| great, that seems easy enough, I really don't know why I had such a hard time figuring this out. I thought I had to do some fancy SQL Server commands like TEXTPTR and WRITETEXT like I saw in this Wrox book a while ago..thanks so much!!! |
|
|
|
|
|
|
Setting a 'pointer' to an image....