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?As fare as I know, SQL Server has no specific support for office files.
So, you have the choice between re-inventing the functionality of document information systems, or to buy some. These systems are storing office files as BLOBs to keep all controls, and they are storing the text in a separate TEXT field to enable searching.
However, there is a third way: store only the path to the documents on your netwerk, and use Office's functionality to prevent users to open the same document twice.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment