Tag Archives: T-SQL

Replacing NULLs in a Left Join–#SQLNewBlogger

I saw someone ask a question on how to replace NULL in a left join and decided to write a post. I realized this is one of those simple things that people new to SQL might not get. Another post … Continue reading

Posted in Blog | Tagged , | Leave a comment

New in SQL Server 2022 – Generate_Series

One of the new language features added in SQL Server 2022 is the GENERATE_SERIES function. This allows you to generate a SELECT * FROM GENERATE_SERIES(start=1, stop=7) This gives me a simple sequence of numbers in a result set, with the … Continue reading

Posted in Blog | Tagged , , | Comments Off on New in SQL Server 2022 – Generate_Series

Using a Regular Expression to Detect a Number–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Here are some hints to get started. I had a customer recently that was looking to work with Data … Continue reading

Posted in Blog | Tagged , , | Comments Off on Using a Regular Expression to Detect a Number–#SQLNewBlogger

T-SQL Tuesday #151 Coding Standards

This month the T-SQL Tuesday blog party is hosted by my good friend, Mala. This is her fourth time hosting and she has a good topic this time. While I love her hosting, and a few others, I would like … Continue reading

Posted in Blog | Tagged , , | 1 Comment