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,081 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,919 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,064 reads
Blogs
A Couple Quick GENERATE_SERIES Tests
By Steve Jones
I had someone reach out about generate_series() recently, saying they hadn’t realized this was...
How I passed the DP-700 Exam
I recently took and passed the DP-700 exam, which is required for the Microsoft...
Which approach to take: Build it, buy it, cloud it?
As a Consultant, I would typically answer with – it depends! Then a typical...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
How to Download and Restore AdventureWorks 2019 Database
Comments posted to this topic are about the item How to Download and Restore...
Tracking Table Sizes
Comments posted to this topic are about the item Tracking Table Sizes
Question of the Day
Counting Bits IV
What does this code return in SQL Server 2022+?
select bit_count(2.4)See possible answers