Recursive SQL queries

Recursion Recursion is the technique in which a function calls itself from within its own body.You can find out more about what is recursion and see some examples in various programming languages, a good resource is this one. Common Table Expression It is possible to achieve a recursion within a SQL query.This is possible with … Continue reading Recursive SQL queries

Search for an object in SQL Server

Photo by Oleg Ivanov on Unsplash If you have a big database structure with lots of databases, plenty of tables, views, stored procedures, functions, etc., sometimes you are lost in all the objects in your server. The good news is that there are ways to handle this situation. sys.objects view You can easily find an object in your … Continue reading Search for an object in SQL Server