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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Saving file in sql

Author  Topic 

Exir
Posting Yak Master

151 Posts

Posted - 2008-12-22 : 00:34:14
I know it is possible to save picture files in sql data base but i have no idea neither about pdf files nor how can i save them in data base and how much can be its size. please guide me.
What about text file? Is it possible to save text in database? how many characters are allowed?

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2008-12-22 : 14:32:29
A typical solution is to save documents, images, etc on the file system. Use the database to store file attributes such as the location path, size, etc. Most applications have more robust functionality for dealing with documents and file system objects (compared to Sql Server).

Be One with the Optimizer
TG
Go to Top of Page
   

- Advertisement -