How do I insert a word doc into a varbinary(max) field for full-text indexing

Need to start learning to use full-text and need to know how to insert word docs, emails, into the database. How is metadata retirieved from these sources and are they loaded into separate tables fields

Thanks

Answer this question

How do I insert a word doc into a varbinary(max) field for full-text indexing

Chris Harry

Looks like I got my answer:

USE AdventureWorks
GO
CREATE TABLE myTable(FileName nvarchar(60), 
 FileType nvarchar(60), Document varbinary(max))
GO

INSERT INTO myTable(FileName, FileType, Document) 
  SELECT 'Text1.txt' AS FileName, 
   '.txt' AS FileType, 
   * FROM OPENROWSET(BULK N'C:\Text1.txt', SINGLE_BLOB) AS Document
GO

Thanks

How do I insert a word doc into a varbinary(max) field for full-text indexing

Answer this question