Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003

    Unhappy Unanswered: Can I store a file in a SQL Server Database?

    I have SQL Server 2000 and I have to make a table for storing Word, Excel or maybe some other Microsoft Office files. What data type should I use for this? Can I search through the stored files by words in a stored documents using a query and how?
    Also the database where this table is created should provide similar functionality as a file server open, edit, check in, and check out on stored files. Can I do this in SQL Server 2000?

  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    You can store documents in the text or image data type.

    You probably can't search on them, but your could store a summary in a character-based field with the record, or a column that just contains keywords.

    Yes, you can provide functionality similar to a just have to write it all yourself.

    I can tell you that you are looking at a daunting project here that will likely involve complex coding. The user-interface will probably also prove difficult.

    Perhaps somebody else on the forum will see this post and could recommend some professionally designed 3rd party software for document management?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts