Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE database_name;
- DECLARE @root nvarchar(100);
- DECLARE @fullpath nvarchar(1000);
- SELECT @root = FileTableRootPath();
- SELECT @fullpath = @root + file_stream.GetFileNamespacePath()
- FROM filetable_name
- WHERE name = N'document_name';
- PRINT @fullpath;
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement