cte Archives - SQLRelease

Reverse the string with a delimiter (Recursive CTE)

In this article, we are going to learn how we can “Reverse string in sql server” with some specified delimiter e.g, based on space or comma or tilde or semi-colon etc; If you will input “A B C”, the output should be as “C B A” Solution: Lets assume space as a delimiter in this example […]

Reverse the string with a delimiter (Recursive CTE) Read More »

Common Table Expressions

What is CTE (Common Table Expressions) A common table expression (CTE) is a temporary result set accessible within the execution scope of a single SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. CTE does not hold any physical space in database like a derived table. But Unlike a derived table, a CTE can be self-referencing