February 27, 2025
Our free SDU Tools for developers and DBAs, now includes a very large number of tools, with procedures, functions, and views. I do a lot of […]
February 26, 2025
SQL Server 2008 and later support a VALUES clause. We can use this to construct a table on the fly. In the example above, you can […]
February 25, 2025
Our free SDU Tools for developers and DBAs, now includes a very large number of tools, with procedures, functions, and views. I do a lot of […]
February 24, 2025
In the previous T-SQL 101 post, I mentioned that some subqueries depend upon the outer query and others don’t. That’s the distinction between what are called […]
February 23, 2025
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around […]
February 22, 2025
Sometimes what we’re interested in is just whether or not a row exists. In the example shown, I’m saying I want to select product ID and […]
February 21, 2025
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around […]
February 20, 2025
Another way that we can use a subquery is in place of a list of values. I’ve previously shown how the IN operator allows us to […]
February 19, 2025
Our free SDU Tools for developers and DBAs, now includes a very large number of tools, with procedures, functions, and views. A request that I had […]
February 16, 2025
Subqueries allow us to reuse data from one query in another query. There are three basic ways that this can work: Row sets (tables) – a […]
February 15, 2025
This is a post in the SQL Interview series. These aren’t trick or gotcha questions, they’re just questions designed to scope out a candidate’s knowledge around […]
February 14, 2025
We saw in previous post that we had a function called GetRecentOrders that gets the most recent orders for a particular cinema. But what if we […]