Comment by rawgabbit
2 days ago
It can do loops and recursion. It can use as much memory as it is allowed. It can do general programming via functions and stored procedures.
2 days ago
It can do loops and recursion. It can use as much memory as it is allowed. It can do general programming via functions and stored procedures.
It can't do loops. Unless you're talking about extensions to SQL such as PL/SQL and T-SQL.
It can do loops. Recursive CTEs has been in the standard since SQL:1999
https://en.wikipedia.org/wiki/SQL:1999