SQL Server 2012 FileTables in T-SQL part 3: hierarchyid methods
So finally, we get to using FileTable's path_locator column with the methods of hierarchyid. To pick up where we left off, remember that hierarchyid has
So finally, we get to using FileTable's path_locator column with the methods of hierarchyid. To pick up where we left off, remember that hierarchyid has
So the functions/methods that I wrote about in previous post are needed because FileTables don't store the UNC path name of the file, they store
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.