MySQL and SQL Server – Oracle CONNECT BY PRIOR for Recursive, Hierarchical Data

Posted on Feb 24, 2010 in Technical Tips | 0 comments

Recursive queries are something I have used many, many times over the years to build dynamic, n-tiered hierarchies. Oracle’s CONNECT BY PRIOR is awesome.

Does anyone know if this is possible in SQL Server or MySQL?

From what I understand, stored procedures would need to be used in MySQL and SQL Server to accomplish what Oracle does in one SQL statement with CONNECT BY PRIOR. I need to dig into the other databases a bit further to verify, but I am interested in any elegant solutions people have come up with if you would like to share.

Related Information:

1. Staging Data with MySQL, CSVed, and XAMPP

   The Task: Take and load,...

2. Oracle Database vs Sun MySQL

   Well, this is a topic...

3. Oracle XE Limitations (CPU, RAM, Data Limits)

   I was trying to make...

4. Registering Oracle HTTP Server with Oracle WebLogic Server

   For Fusion Middleware Control to...

5. TOAD for Oracle 9 or TOAD 10 – 64-bit Windows – ORA-12154: could not resolve the connect identifier specified or ORA-6413: connection not open

   I recently downloaded the new...

6. Oracle Application Server Startup and Shutdown Script Generator – FREE

   Complete the below to receive...

7. Server Technologies

   M&S Consulting has experience designing...

8. Copy Table Columns and Data

   As you may know, in...