Advertisement
bondboy

File Table Path Script

Jun 16th, 2019
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. USE database_name;
  2. DECLARE @root nvarchar(100);
  3. DECLARE @fullpath nvarchar(1000);
  4.  
  5. SELECT @root = FileTableRootPath();
  6. SELECT @fullpath = @root + file_stream.GetFileNamespacePath()
  7. FROM filetable_name
  8. WHERE name = N'document_name';
  9.  
  10. PRINT @fullpath;
  11. GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement