Storing hyperlinks to database | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Storing hyperlinks to database

This is my problem, I have been given 200 pdf files that the client either wants to store within SQL or have hyperlinks stored within SQL referencing the storage of the files within a directory on the server. I know how to put the files into SQL but I have never tried to create the hyperlink option. Is there a way to write a proc that would take the file names within a directory and store the links to them within SQL? [?]mailto: [email protected] Joel
Help, I am lost again!!!

I’m not sure what you mean, since the problems looks trivial – just construct a hyperlink string and insert it into a varchar field. What am I missing here? — Rediscover the web