Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Data Files & SQL Help
- Thread starter cfgcjm
- Start date
I'd recommend saving the files to the file system and saving a link to the image in your database.
[small]----signature below----[/small]
Majority rule don't work in mental institutions
My Crummy Web Page
[small]----signature below----[/small]
Majority rule don't work in mental institutions
My Crummy Web Page
I'll echo AlexCuse's general recommendation to store only URLs/file paths in the database that point to the image, but if you really want to store these in the database, and assuming you are using SQL Server 2005 or later, use VARBINARY(MAX) as a column type.
--------------
SQLS metasearch
--------------
SQLS metasearch
right now I second the other two, IN SQL 2008 I would look at FileStream, it stores the file in a folder but it is still transactional
Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions
Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions
- Status
Similar threads
- Locked
- Question