4
Shouts
spam Shout it Mute it

Use xp_dirtree SQL Server Stored Procedure and Recursive CTE Query to List Hierarchical Structure of File Folders
published 825 days, 4 hours, 25 minutes ago posted by tsqltsql 828 days, 13 hours, 34 minutes ago
Saturday, February 19, 2011 6:14:56 PM GMT Wednesday, February 16, 2011 9:05:49 AM GMT

Use xpdirtree SQL Server Stored Procedure and Recursive CTE Query to List Hierarchical Structure of File Folders T-SQL developers can use xpdirtree SQL Server stored procedure to display subdirectory list beneath a given file folder as input parameter. xpdirtree extended stored procedure is one of the SQL Server undocumented stored procedures. In this SQL tutorial, we will use SQL Server xpdirtree stored procedure with T-SQL recursive CTE query in order to list hierarchical structure of file folders.

category: Data | clicked: 35 | | source: www.kodyaz.com | show counter code
tags: SQL Server, SQL, T-SQL

No comments yet, be the first one to post comment.

To post your comment please login or signup