What is CTE?	It means Common Table Expresión. Specifies a temporary named result set.
What must contain the recursive CTE?	At least two CTE query definitions, an anchor member and a recursive member. The anchor member must be put before the first recursive member definition. All CTE query definitions are anchor members unless they reference the CTE itself.
How do you combine anchor members?	Anchor members must be combined by one of these set operators: UNION ALL, UNION, INTERSECT or EXCEPT.
How do you combine an anchor member with a recursive member?	With UNION ALL.
How can we prevent an infinite loop in a CTE?	We can use MAXRECURSION. Example: OPTION(MAXRECURSION 10);
When do we need to use a CTE?	* When we need to apply a recursive. * When we want to use an alias column in an impossible logical query phase. * Substitute for a view, you do NOT have to store the definition in metadata. * Reference the resulting table múltiple times in the same statement. * Enable GROUPING BY a column that is derived from a scalar subselect, or a function that is either not deterministic or has an eternal access.

Descubre

Acerca de Nosotros

Explore Tarjetas

Tarjetas de Aprendizaje relacionadas