INSERT
INTO dbo . FTSDocs ( DocID , Titel , [FileName] , FileExtension , DocContent )
SELECT 1 , 'mytest doc' , 'mytest.doc' , '.doc'
,
* FROM OPENROWSET ( BULK N'E:/cofei/LnSQLSERVER/mytest.doc' , SINGLE_BLOB ) AS
DocContent
GO
INSERT
INTO dbo . FTSDocs ( DocID , Titel , [FileName] , FileExtension , DocContent )
SELECT 1 , 'mytest doc' , 'mytest.doc' , '.doc'
,
* FROM OPENROWSET ( BULK N'E:/cofei/LnSQLSERVER/mytest.doc' , SINGLE_BLOB ) AS
DocContent
GO