Set-Based String Splitting table function
Describe and provide a set-based method that takes a multiple character split term and returns as a table
2018-03-19
3,142 reads
bevan ward
Solve Sudoku with T-SQL - Part 1
A Sudoku solution can be resolved using a single select statement. The first article shows this method and next how this can be optimised to resolve complex puzzles in seconds.
2018-02-20
3,969 reads
Formatted ASCII Results from a SELECT
Generate aligned output from SELECT statement for code comments using a simple stored procedure.
2018-01-18
3,119 reads
Blogs
AZ-900: Microsoft Azure Fundamentals – The Ultimate Beginner’s Guide to Cloud Mastery
By Rohit Garg
In an era where cloud computing drives innovation, understanding its fundamentals is no longer...
Moving to Rancher Desktop
By Steve Jones
I’ve been very happy with Docker Desktop for years, running it on both laptop...
Logging in Azure Data Factory data flows
By Rayis Imayev
(2025-June-15) Long gone are the days when a data engineer could simply focus on building...
Forums
What is Between?
Comments posted to this topic are about the item What is Between?
Inside the Walls of Azure SQL MI
Comments posted to this topic are about the item Inside the Walls of Azure...
SQL Server 2025 Excitement
Comments posted to this topic are about the item SQL Server 2025 Excitement
Question of the Day
What is Between?
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers