Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Wednesday, June 21, 2017

get full path from sys.xp_dirtree

SQLServerCentral » Latest topics
get full path from sys.xp_dirtree
hello all. I have this script: IF OBJECT_ID('tempdb..#DirectoryTree') IS NOT NULL DROP TABLE #DirectoryTree; CREATE TABLE #DirectoryTree ( id int IDENTITY(1,1) ,subdirectory nvarchar(512) ,depth int ,isfile bit ,

No comments: