Re: storing and searching office docs in SQL

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Vishal Parkar (REMOVE_THIS_vgparkar_at_yahoo.co.in)
Date: 08/19/04 

Date: Thu, 19 Aug 2004 06:33:33 +0530

>> Can you store an office doc, like a word or excel document in a SQL
field,<<

you can store word documents using image datatypes in SQL Server, internally
sql server stores this data into binary format.

>> and then somehow search within the contents of the office document for
words.<<

Since content of the image datatype are binary in nature, you can not
straightaway search for the content of word document once you store them
image datatype.

all you can do is ,store documents in one column (image) and have another
column (text/varchar according to the size of the contents of the document)
column which will store the content of the word document (in pure text,
which will not have any kind of word fomatting). You can implement search
functionality in the document by running standard sql statement against this
column. 

-- 
Vishal Parkar
vgparkar@yahoo.co.in | vgparkar@hotmail.com

Relevant Pages

  • Re: storing and searching office docs in SQL
    ... You CAN both store and search the contents of the MS Word ... files stored in an SQL Table's FT-enable IMAGE column, ... FTS CONTAINS or FREETEXT to search the contents of that MS word document: ... exec sp_fulltext_database 'enable' -- only do this once! ...
    (microsoft.public.sqlserver.programming)
  • Re: Problems with querying date field
    ... >> If you want to put a database somewhere for safekeeping, ... database - SQL isn't about persistence, ... says nothing about the physical storage media to be used. ... store data on a tape, or a disk, or a CD, or a file, or any physical ...
    (microsoft.public.sqlserver.programming)
  • Re: Should I place a Domain controller in each of the 40 stores?
    ... They should be able to do that, one common way is to use a SQL account in an mixed SQL authentication enviroment where the Apps use a dedicated local SQL account to connect to the DB, but again the app may work differently. ... Also note that although it is possible, it's NOT recommended to cluster for example a SQL server that is also a DC. ... We plan to place a SQL server in each store as part of a new POS ... implementation and also migrate to XP Embedded for the POS terminals. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Need Aggregate Query Help!!!
    ... else than what I am suggesting. ... I was using Access SQL with JET backend. ... (SELECT EmpName, Store, SUM(Qty) ... GROUP BY EmpName, Store) as B ...
    (microsoft.public.access.queries)
  • Re: Problem with PR_ENTRY_ID and uniqueness
    ... have to define a huge column width for SQL column. ... two pieces and store each independently. ... intend to save more than one Exchange Server Store ... One last thing about Exchange Re-Using EntryIDs. ...
    (microsoft.public.win32.programmer.messaging)