February 9, 2025
We saw how UNION and UNION ALL worked in the last T-SQL 101 post. Sometimes you want to work with two (or more) row sets in […]
February 8, 2025
Our free SDU Tools for developers and DBAs, now includes a very large number of tools, with procedures, functions, and views. Applications often need to display […]
February 8, 2025
There are times when you need to connect together two sets of results into a single result set. The UNION statement is the way we do […]
February 7, 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 7, 2025
Our free SDU Tools for developers and DBAs, now includes a very large number of tools, with procedures, functions, and views. Excel is fascinating in how […]
February 6, 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 6, 2025
I’ve made several posts about joins but one option that I haven’t talked about as yet, are what are called non-equi joins. These are less common, […]
February 5, 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 5, 2025
One thing you might not have considered is that a table can also be joined to itself. Imagine that I want a list of employees, but […]
February 4, 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 4, 2025
Of course, you might also need to join more than two tables. The example above shows how to do that. I started with the Orders table, […]
February 3, 2025
Our free SDU Tools for developers and DBAs, now includes a very large number of tools, with procedures, functions, and views. A while back, we added […]