How to insert records into file table of DENALI?

Rajnilari2015
Posted by Rajnilari2015 under Sql Server category on | Points: 40 | Views : 1131
The below command will do that

INSERT INTO [dbo].[FileTableTb]
([name],[file_stream])
SELECT
'Test.pdf', * FROM OPENROWSET(BULK N'C:\Test.pdf', SINGLE_BLOB) AS Record


This inserts a record by the name Test.pdf to the File Table.

Comments or Responses

Login to post response