SQL Server tree query single table instance code, SQL Server single table

SQL Server tree query single table instance code, SQL Server single table

-- TREE SQL query WITH TREE AS (-- create a virtual table SELECT * FROM sys_organiz -- specify the table to be queried WHERE organize_code = '2013' -- specify the parent node condition UNION ALL -- UNION query SELECT sys_organiz. * FROM sys_organiz, tree where tree. organize_code = sys_organiz.organize_parent_code) SELECT * from tree;

Note the Red Section * And sys_organiz. * This parameter must be specified. Otherwise, an error is reported: All queries that are merged using the UNION, INTERSECT, or EXCEPT t operator must have the same number of expressions in the target list.

Summary

The above is a small series of SQL Server tree structure query single table, hope to help you, if you have any questions, please leave a message, the small series will reply to you in a timely manner. Thank you very much for your support for the help House website!