Methods for implementing recursion using with in SQL Server 2005 _mssql2005

Copy Code code as follows:

With Fw_requestion_note_temp (old_apply_id) as (--take the root node into the temporary table
SELECT old_apply_id from fw_requestion_note--where old_apply_id = ' E741470e-8b5c-4f91-9b03-c7474d103aef '
--data that recursively takes its byte point from the data that has been fetched

UNION all SELECT fw.old_apply_id from Fw_requestion_note FW
INNER JOIN fw_requestion_note_temp temp on fw.apply_id = temp.old_apply_id) SELECT old_apply_id from fw_requestion_note_t Emp