For this article, we are going to examine the benefit of using stored procedures that simply return a result set (i.e. a stored procedure that has a SELECT statement). Before we do a shallow dive into this functionality, it is worth noting that SQL Server has three methods of returning data from a stored procedure: … Continue reading Stored Procedures: Returning Data Using a Result Set →

Microsoft has the following page if you have always wondered what the different symbols and formatting mean when viewing syntax examples. Transact-SQL Syntax Conventions (Transact-SQL) - SQL Server | Microsoft Docs It's always a good exercise to review the DDL statements below and take stock of which options you understand or need to brush up … Continue reading SQL Syntax Conventions →

Welcome to a new year. I haven't utilized the blog portion of my website yet, but I figured a nice year-end review would be a good topic. I'm not expecting many people to read this, so if you are, hello and welcome! This site has become quite popular considering its niche subject of SQL puzzles, … Continue reading Happy New Year: 2022 →