Tag Archives: T-SQL

STRING_SPLIT Basics–#SQLNewBlogger

Posted on October 18, 2021 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I saw a post on using STRING_SPLIT() with cross apply recently, and as I was reading, I realized that … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

T-SQL Tuesday #143 – Short Code

Posted on October 13, 2021 by way0utwest

I’m late, but I wanted to get this out. I started the post, then got distracted with travel to Europe late last week. In any case, this month the host for T-SQL Tuesday is John McCormack, with his invite to … Continue reading →

Posted in Blog | Tagged , , | Comments Off on T-SQL Tuesday #143 – Short Code

Using NULLIF–#SQLNewBlogger

Posted on October 6, 2021 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran across the NULLIF() function recently, and I realized I’d never used it in code. It’s an interesting … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Using NULLIF–#SQLNewBlogger

To Inifinity and Beyond With 1=1

Posted on September 22, 2021 by way0utwest

There is one thing that Aaron Bertrand won’t get mad at me for doing and that’s creating an infinite loop with a WHILE (1=1) pattern. He wrote about this recently in a tip, noting that it’s easy to create an … Continue reading →

Posted in Editorial | Tagged | 2 Comments