March 12, 2025
To insert new rows into a table, you will mostly use the INSERT statement. In the example above, I’ve inserted one row into the dbo.CinemaGroups table. […]
March 11, 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 […]
March 10, 2025
There are times that you need to be able to query the database and its internal structures rather than querying the user tables. In the example […]
March 9, 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 […]
March 8, 2025
It’s also possible to create the command dynamically before you execute it. In the example above, I’ve set a number of different parts of a SQL […]
March 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 […]
March 6, 2025
In T-SQL, the way we execute a stored procedure is to use the EXECUTE statement. We can write it as EXECUTE or as EXEC. You’ll almost […]
March 5, 2025
In a previous post, I described the issues with measuring quantities in warehousing systems. I showed how you could well need to measure more than just […]
March 4, 2025
Stored procedures are prepackaged groups of T-SQL statements. They can also be written in other languages, but most of the time they’ll be written in T-SQL. […]
March 2, 2025
I mentioned earlier that CTEs can be used to clean up or tidy more complicated queries. You will find people though, who really don’t like them […]
March 1, 2025
After one of my recent posts, I was asked what an outer quantity was. This term is common in warehousing and logistics. So many business applications assume […]
February 28, 2025
One of the challenges with subqueries is they can get very, very messy if you need to use them more than once. So for example, in […]