Microsoft® SQL Server 2012 Unleashed

Copying Files to the FileTable

You can copy files to the FileTable using Windows Explorer or a similar program that uses a Windows API to access the file system. Before copying files, make sure that you know where the folder exists on your file system. This can be easily accomplished using the FileTableRootPath function, as shown in the following example. The first parameter of this function is the FileTable_Name. The second parameter sets an option that determines how the path will be returned; option #2 returns the complete server path:

Click here to view code image

select FileTableRootPath ( 'dbo.FileTable1', 2 )--Sample results from FileTableRootPath\\chris_lt\INST2012\FileData\FileTable1

You can also easily navigate to the FileTable folder ...