What is recursive CTE in SQL Server?

Related questions

1. Is MySQL T SQL?
2. Can we create temporary table in stored procedure?
3. Is SQL Server T SQL?
4. What is tempDB in SQL Server?
5. Can we create index on CTE?
6. Is SQL difficult to learn?
7. What are tables and fields in SQL?
8. What is the difference between temp table and table variable?
9. What is the difference between a local and a global temporary table?
10. What is the difference between table variable and temp table?

Tags

1. #which
2. #results
3. #before
4. #executes
5. #query
6. #example
7. #itself
8. #union
9. #recursive
10. #first
11. #above
12. #derived
13. #based
14. #record
15. #process
16. #output
17. #expression
18. #table
19. #common