Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    Macedonia
    Posts
    3

    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
    Location
    Ohio
    Posts
    12,592
    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 file-server...you 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?

    blindman

Posting Permissions

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