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
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 GOThanks
No comments:
Post a Comment