hi,it's a .net web based application as sql server 2005 back-end.. i want to store .txt files into the sql server 2005 using stored procedure.is there a way.. please tell me.. and how to retrieve these .txt files so that user able to download these files.or... please suggest some other way for faster accessing..which will not effect database performance.thnx..
There is a way using a varbinary(MAX) column. For a working sample just have a look here: http://stackoverflow.com/questions/961104/store-and-retrieve-zip-file-in-sql-server-2005
Just a thought that why you need to store the .tXT files to database, are they not simply imported into database?
Welcome! Then you should make sure that your autosignature doesn't suggest you are trying to spam this forum!
